APPS.PER_PER_BUS dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 2917: -- there a row in pay_legislative_field_info for the current legislation code

2913: -- ---------------------------------------------------------------------------
2914: --
2915: -- Description:
2916: -- Checks that the town of birth parameter corresponds to a valid lookup value if
2917: -- there a row in pay_legislative_field_info for the current legislation code
2918: -- and the field_name of 'TOWN_OF_BIRTH'. (If no row exists in PLFI table then
2919: -- assume this field is free text and under the current legislation is not validated).
2920: --
2921: -- Pre-conditions:

Line 2954: FROM pay_legislative_field_info plfi

2950: --
2951: --
2952: CURSOR csr_plfi is
2953: SELECT rule_type
2954: FROM pay_legislative_field_info plfi
2955: WHERE upper(plfi.field_name) = 'TOWN_OF_BIRTH'
2956: AND plfi.legislation_code = p_legislation_code;
2957: --
2958: l_exists varchar2(1);

Line 3031: -- there a row in pay_legislative_field_info for the current legislation code

3027: -- ---------------------------------------------------------------------------
3028: --
3029: -- Description:
3030: -- Checks that the region of birth parameter corresponds to a valid lookup value if
3031: -- there a row in pay_legislative_field_info for the current legislation code
3032: -- and the field_name of 'REGION_OF_BIRTH'. (If no row exists in PLFI table then
3033: -- assume this field is free text and under the current legislation is not validated).
3034: --
3035: -- Pre-conditions:

Line 3068: FROM pay_legislative_field_info plfi

3064: --
3065: --
3066: CURSOR csr_plfi is
3067: SELECT rule_type
3068: FROM pay_legislative_field_info plfi
3069: WHERE upper(plfi.field_name) = 'REGION_OF_BIRTH'
3070: AND plfi.legislation_code = p_legislation_code;
3071: --
3072: l_exists varchar2(1);