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 1032: IF hr_api.not_exists_in_hr_lookups (

1028: --
1029: -- Check pension category lookup code
1030: --
1031:
1032: IF hr_api.not_exists_in_hr_lookups (
1033: p_effective_date => p_effective_start_date
1034: ,p_lookup_type => 'PQP_PENSION_CATEGORY'
1035: ,p_lookup_code => p_pension_category
1036: )

Line 1122: IF hr_api.not_exists_in_hr_lookups (

1118: --
1119: hr_utility.set_location (l_proc_name, 50);
1120:
1121: --
1122: IF hr_api.not_exists_in_hr_lookups (
1123: p_effective_date => p_effective_start_date
1124: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1125: ,p_lookup_code => l_emp_deduction_method
1126: )

Line 1145: IF hr_api.not_exists_in_hr_lookups (

1141:
1142: --
1143: IF p_eer_deduction_method IS NOT NULL
1144: THEN
1145: IF hr_api.not_exists_in_hr_lookups (
1146: p_effective_date => p_effective_start_date
1147: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1148: ,p_lookup_code => p_eer_deduction_method
1149: )

Line 1187: IF hr_api.not_exists_in_hr_lookups (

1183: --
1184:
1185: IF p_additional_contribution IS NOT NULL
1186: THEN
1187: IF hr_api.not_exists_in_hr_lookups (
1188: p_effective_date => p_effective_start_date
1189: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1190: ,p_lookup_code => p_additional_contribution
1191: )

Line 1215: IF hr_api.not_exists_in_hr_lookups (

1211: --
1212:
1213: IF p_added_years IS NOT NULL
1214: THEN
1215: IF hr_api.not_exists_in_hr_lookups (
1216: p_effective_date => p_effective_start_date
1217: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1218: ,p_lookup_code => p_added_years
1219: )

Line 1243: IF hr_api.not_exists_in_hr_lookups (

1239: --
1240:
1241: IF p_family_widower IS NOT NULL
1242: THEN
1243: IF hr_api.not_exists_in_hr_lookups (
1244: p_effective_date => p_effective_start_date
1245: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1246: ,p_lookup_code => p_family_widower
1247: )

Line 1272: IF hr_api.not_exists_in_hr_lookups (

1268: --
1269:
1270: IF p_fwc_added_years IS NOT NULL
1271: THEN
1272: IF hr_api.not_exists_in_hr_lookups (
1273: p_effective_date => p_effective_start_date
1274: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1275: ,p_lookup_code => p_fwc_added_years
1276: )

Line 1302: IF hr_api.not_exists_in_hr_lookups (

1298: --
1299:
1300: IF p_pension_scheme_type IS NOT NULL
1301: THEN
1302: IF hr_api.not_exists_in_hr_lookups (
1303: p_effective_date => p_effective_start_date
1304: ,p_lookup_type => 'PQP_PENSION_SCHEME_TYPE'
1305: ,p_lookup_code => p_pension_scheme_type
1306: )

Line 1415: IF hr_api.not_exists_in_hr_lookups (

1411: hr_utility.set_location (l_proc_name, 120);
1412:
1413: --
1414:
1415: IF hr_api.not_exists_in_hr_lookups (
1416: p_effective_date => p_effective_start_date
1417: ,p_lookup_type => 'TERMINATION_RULE'
1418: ,p_lookup_code => NVL (
1419: p_termination_rule

Line 3993: l_pension_category hr_lookups.lookup_code%TYPE;

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

Line 3994: l_emp_deduction_method hr_lookups.lookup_code%TYPE;

3990: l_ovn_itr NUMBER;
3991: l_itr_effective_start_dt DATE;
3992: l_itr_effective_end_dt DATE;
3993: l_pension_category hr_lookups.lookup_code%TYPE;
3994: l_emp_deduction_method hr_lookups.lookup_code%TYPE;
3995:
3996: --
3997: BEGIN
3998: --