APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_LEGISLATIVE_FIELD_INFO

Line 164: FROM hr_s_legislative_field_info

160: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
161:
162: CURSOR get_leg_field_info_csr IS
163: SELECT field_name
164: FROM hr_s_legislative_field_info
165: WHERE legislation_code = 'ZZ';
166:
167:
168: CURSOR get_leg_rules_csr IS

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

223: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Route', rec.route_name);
224: END LOOP;
225:
226: write_log('OUTPUT',NULL,NULL,NULL);
227: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Legislative Field Info', 'HR_S_LEGISLATIVE_FIELD_INFO');
228:
229: FOR rec IN get_leg_field_info_csr LOOP
230: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislative Field Info', rec.field_name);
231: END LOOP;

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

558: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_GLOBALS_F',NULL);
559: DELETE hr_s_globals_f;
560: COMMIT;
561:
562: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
563: DELETE hr_s_legislative_field_info;
564: COMMIT;
565:
566: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_SUBGROUPS',NULL);

Line 563: DELETE hr_s_legislative_field_info;

559: DELETE hr_s_globals_f;
560: COMMIT;
561:
562: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
563: DELETE hr_s_legislative_field_info;
564: COMMIT;
565:
566: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_LEGISLATION_SUBGROUPS',NULL);
567: DELETE hr_s_legislation_subgroups;

Line 1287: INSERT into hr_s_legislative_field_info

1283:
1284: -- Used column to column mapping in the insert statement to remove
1285: -- error caused by mismatch in number of fields. Bug No 3720975.
1286:
1287: INSERT into hr_s_legislative_field_info
1288: (FIELD_NAME,
1289: LEGISLATION_CODE,
1290: PROMPT,
1291: VALIDATION_NAME,

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

1844: WHERE legislation_code = 'ZZ';
1845:
1846: --Unpadting Legislative Field Info
1847:
1848: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
1849: UPDATE hr_s_legislative_field_info
1850: SET legislation_code = p_legislation_code
1851: WHERE legislation_code = 'ZZ';
1852:

Line 1849: UPDATE hr_s_legislative_field_info

1845:
1846: --Unpadting Legislative Field Info
1847:
1848: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_LEGISLATIVE_FIELD_INFO',NULL);
1849: UPDATE hr_s_legislative_field_info
1850: SET legislation_code = p_legislation_code
1851: WHERE legislation_code = 'ZZ';
1852:
1853: --Updating Balance Classifications