Package ab_atvincm

Standard functions and procedures for Income Validation Table

Program units

f_code_exists	Determine if the code exists in the table
f_get_description	Return description for the code

Cursors

CURSOR atvincm_c(
    p_code  atvincm.atvincm_code%TYPE)
 RETURN atvincm%ROWTYPE;

f_code_exists

Function f_code_exists(p_code atvincm.atvincm_code%TYPE) RETURN VARCHAR2

Determine if the code exists in the table

Parameters

p_code

Code for an income level.

Returns

Y if found, otherwise N

f_get_description

Function f_get_description(p_code atvincm.atvincm_code%TYPE)
  RETURN VARCHAR2

Return description for the code

Parameters

p_code

Code for an income level.

Returns

Description