APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_BALANCE_CATEGORIES_F

Line 485: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CATEGORIES_F',NULL);

481: DELETE hr_s_sub_classn_rules_f;
482: COMMIT;
483: /*bug 10212578 Begin */
484:
485: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CATEGORIES_F',NULL);
486: DELETE hr_s_balance_categories_f;
487: COMMIT;
488: /*bug 10212578 End */
489:

Line 486: DELETE hr_s_balance_categories_f;

482: COMMIT;
483: /*bug 10212578 Begin */
484:
485: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CATEGORIES_F',NULL);
486: DELETE hr_s_balance_categories_f;
487: COMMIT;
488: /*bug 10212578 End */
489:
490: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_TYPES',NULL);

Line 1358: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Categories', 'HR_S_BALANCE_CATEGORIES_F');

1354: --Balance Classifications
1355:
1356: write_log('LOG',NULL,NULL,NULL);
1357:
1358: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Categories', 'HR_S_BALANCE_CATEGORIES_F');
1359: FOR rec IN get_balance_cat_csr LOOP
1360: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Categories', rec.balance_category_id);
1361:
1362: INSERT INTO hr_s_balance_categories_f

Line 1362: INSERT INTO hr_s_balance_categories_f

1358: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Categories', 'HR_S_BALANCE_CATEGORIES_F');
1359: FOR rec IN get_balance_cat_csr LOOP
1360: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Categories', rec.balance_category_id);
1361:
1362: INSERT INTO hr_s_balance_categories_f
1363: ( BALANCE_CATEGORY_ID
1364: ,CATEGORY_NAME
1365: ,EFFECTIVE_START_DATE
1366: ,EFFECTIVE_END_DATE

Line 1867: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CATEGORIES_F',NULL);

1863: SET report_qualifier = p_legislation_code
1864: WHERE report_qualifier = 'ZZ';
1865:
1866: --Updating Balance Categories
1867: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CATEGORIES_F',NULL);
1868: UPDATE hr_s_balance_categories_f
1869: SET legislation_code = p_legislation_code
1870: WHERE legislation_code = 'ZZ';
1871:

Line 1868: UPDATE hr_s_balance_categories_f

1864: WHERE report_qualifier = 'ZZ';
1865:
1866: --Updating Balance Categories
1867: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CATEGORIES_F',NULL);
1868: UPDATE hr_s_balance_categories_f
1869: SET legislation_code = p_legislation_code
1870: WHERE legislation_code = 'ZZ';
1871:
1872: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',20);