APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_LEGISLATIVE_FIELD_INFO

Line 158: FROM hr_s_legislative_field_info

154: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
155:
156: CURSOR get_leg_field_info_csr IS
157: SELECT field_name
158: FROM hr_s_legislative_field_info
159: WHERE legislation_code = 'ZZ';
160:
161:
162: CURSOR get_leg_rules_csr IS

Line 221: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Legislative Field Info', 'HR_S_LEGISLATIVE_FIELD_INFO');

217: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
218: END LOOP;
219:
220: write_log('OUTPUT',NULL,NULL,NULL);
221: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Legislative Field Info', 'HR_S_LEGISLATIVE_FIELD_INFO');
222:
223: FOR rec IN get_leg_field_info_csr LOOP
224: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislative Field Info', rec.field_name);
225: END LOOP;

Line 500: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATIVE_FIELD_INFO',NULL);

496: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_GLOBALS_F',NULL);
497: DELETE hr_s_globals_f;
498: COMMIT;
499:
500: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
501: DELETE hr_s_legislative_field_info;
502: COMMIT;
503:
504: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_SUBGROUPS',NULL);

Line 501: DELETE hr_s_legislative_field_info;

497: DELETE hr_s_globals_f;
498: COMMIT;
499:
500: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
501: DELETE hr_s_legislative_field_info;
502: COMMIT;
503:
504: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_SUBGROUPS',NULL);
505: DELETE hr_s_legislation_subgroups;

Line 1086: INSERT into hr_s_legislative_field_info

1082:
1083: -- Used column to column mapping in the insert statement to remove
1084: -- error caused by mismatch in number of fields. Bug No 3720975.
1085:
1086: INSERT into hr_s_legislative_field_info
1087: (FIELD_NAME,
1088: LEGISLATION_CODE,
1089: PROMPT,
1090: VALIDATION_NAME,

Line 1477: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATIVE_FIELD_INFO',NULL);

1473: WHERE legislation_code = 'ZZ';
1474:
1475: --Unpadting Legislative Field Info
1476:
1477: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
1478: UPDATE hr_s_legislative_field_info
1479: SET legislation_code = p_legislation_code
1480: WHERE legislation_code = 'ZZ';
1481:

Line 1478: UPDATE hr_s_legislative_field_info

1474:
1475: --Unpadting Legislative Field Info
1476:
1477: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
1478: UPDATE hr_s_legislative_field_info
1479: SET legislation_code = p_legislation_code
1480: WHERE legislation_code = 'ZZ';
1481:
1482: --Updating Balance Classifications