APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on HR_LOOKUPS

Line 237: l_emp_deduction_method hr_lookups.lookup_code%TYPE

233: := 'L_STOPPER';
234: l_itr_rule_type pay_iterative_rules_f.iterative_rule_type%TYPE
235: := 'S';
236: l_exc_itr_rule_id VARCHAR2 (1);
237: l_emp_deduction_method hr_lookups.lookup_code%TYPE
238: := p_emp_deduction_method;
239:
240: --
241:

Line 1028: IF hr_api.not_exists_in_hr_lookups (

1024: --
1025: -- Check pension category lookup code
1026: --
1027:
1028: IF hr_api.not_exists_in_hr_lookups (
1029: p_effective_date => p_effective_start_date
1030: ,p_lookup_type => 'PQP_PENSION_CATEGORY'
1031: ,p_lookup_code => p_pension_category
1032: )

Line 1118: IF hr_api.not_exists_in_hr_lookups (

1114: --
1115: hr_utility.set_location (l_proc_name, 50);
1116:
1117: --
1118: IF hr_api.not_exists_in_hr_lookups (
1119: p_effective_date => p_effective_start_date
1120: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1121: ,p_lookup_code => l_emp_deduction_method
1122: )

Line 1141: IF hr_api.not_exists_in_hr_lookups (

1137:
1138: --
1139: IF p_eer_deduction_method IS NOT NULL
1140: THEN
1141: IF hr_api.not_exists_in_hr_lookups (
1142: p_effective_date => p_effective_start_date
1143: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1144: ,p_lookup_code => p_eer_deduction_method
1145: )

Line 1183: IF hr_api.not_exists_in_hr_lookups (

1179: --
1180:
1181: IF p_additional_contribution IS NOT NULL
1182: THEN
1183: IF hr_api.not_exists_in_hr_lookups (
1184: p_effective_date => p_effective_start_date
1185: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1186: ,p_lookup_code => p_additional_contribution
1187: )

Line 1211: IF hr_api.not_exists_in_hr_lookups (

1207: --
1208:
1209: IF p_added_years IS NOT NULL
1210: THEN
1211: IF hr_api.not_exists_in_hr_lookups (
1212: p_effective_date => p_effective_start_date
1213: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1214: ,p_lookup_code => p_added_years
1215: )

Line 1239: IF hr_api.not_exists_in_hr_lookups (

1235: --
1236:
1237: IF p_family_widower IS NOT NULL
1238: THEN
1239: IF hr_api.not_exists_in_hr_lookups (
1240: p_effective_date => p_effective_start_date
1241: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1242: ,p_lookup_code => p_family_widower
1243: )

Line 1268: IF hr_api.not_exists_in_hr_lookups (

1264: --
1265:
1266: IF p_fwc_added_years IS NOT NULL
1267: THEN
1268: IF hr_api.not_exists_in_hr_lookups (
1269: p_effective_date => p_effective_start_date
1270: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1271: ,p_lookup_code => p_fwc_added_years
1272: )

Line 1298: IF hr_api.not_exists_in_hr_lookups (

1294: --
1295:
1296: IF p_pension_scheme_type IS NOT NULL
1297: THEN
1298: IF hr_api.not_exists_in_hr_lookups (
1299: p_effective_date => p_effective_start_date
1300: ,p_lookup_type => 'PQP_PENSION_SCHEME_TYPE'
1301: ,p_lookup_code => p_pension_scheme_type
1302: )

Line 1411: IF hr_api.not_exists_in_hr_lookups (

1407: hr_utility.set_location (l_proc_name, 120);
1408:
1409: --
1410:
1411: IF hr_api.not_exists_in_hr_lookups (
1412: p_effective_date => p_effective_start_date
1413: ,p_lookup_type => 'TERMINATION_RULE'
1414: ,p_lookup_code => NVL (
1415: p_termination_rule

Line 3990: l_pension_category hr_lookups.lookup_code%TYPE;

3986: l_rowid ROWID;
3987: l_ovn_itr NUMBER;
3988: l_itr_effective_start_dt DATE;
3989: l_itr_effective_end_dt DATE;
3990: l_pension_category hr_lookups.lookup_code%TYPE;
3991: l_emp_deduction_method hr_lookups.lookup_code%TYPE;
3992:
3993: --
3994: BEGIN

Line 3991: l_emp_deduction_method hr_lookups.lookup_code%TYPE;

3987: l_ovn_itr NUMBER;
3988: l_itr_effective_start_dt DATE;
3989: l_itr_effective_end_dt DATE;
3990: l_pension_category hr_lookups.lookup_code%TYPE;
3991: l_emp_deduction_method hr_lookups.lookup_code%TYPE;
3992:
3993: --
3994: BEGIN
3995: --