APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_BALANCE_CLASSIFICATIONS

Line 169: FROM hr_s_balance_classifications pbc

165: WHERE legislation_code = 'ZZ';
166:
167: CURSOR get_balance_class_csr IS
168: SELECT distinct pbc.balance_classification_id, pbt.balance_name bname
169: FROM hr_s_balance_classifications pbc
170: ,hr_s_balance_types pbt
171: WHERE pbc.legislation_code ='ZZ'
172: AND pbc.balance_type_id = pbt.balance_type_id;
173:

Line 235: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');

231: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislation Rule', rec.rule_type);
232: END LOOP;
233:
234: write_log('OUTPUT',NULL,NULL,NULL);
235: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');
236:
237: FOR rec IN get_balance_class_csr LOOP
238: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Balance Classification for balance', rec.bname);
239: END LOOP;

Line 436: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);

432: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_TYPES',NULL);
433: DELETE hr_s_balance_types;
434: COMMIT;
435:
436: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);
437: DELETE hr_s_balance_classifications;
438: COMMIT;
439:
440: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);

Line 437: DELETE hr_s_balance_classifications;

433: DELETE hr_s_balance_types;
434: COMMIT;
435:
436: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);
437: DELETE hr_s_balance_classifications;
438: COMMIT;
439:
440: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);
441: DELETE hr_s_defined_balances;

Line 1112: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');

1108:
1109: --Balance Classifications
1110:
1111: write_log('LOG',NULL,NULL,NULL);
1112: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');
1113: FOR rec IN get_balance_class_csr LOOP
1114: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Classifications', rec.balance_classification_id);
1115:
1116: INSERT INTO hr_s_balance_classifications

Line 1116: INSERT INTO hr_s_balance_classifications

1112: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');
1113: FOR rec IN get_balance_class_csr LOOP
1114: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Classifications', rec.balance_classification_id);
1115:
1116: INSERT INTO hr_s_balance_classifications
1117: ( balance_classification_id
1118: ,business_group_id
1119: ,legislation_code
1120: ,balance_type_id

Line 1484: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CLASSIFICATIONS',NULL);

1480: WHERE legislation_code = 'ZZ';
1481:
1482: --Updating Balance Classifications
1483:
1484: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CLASSIFICATIONS',NULL);
1485: UPDATE hr_s_balance_classifications
1486: SET legislation_code = p_legislation_code
1487: WHERE legislation_code = 'ZZ';
1488:

Line 1485: UPDATE hr_s_balance_classifications

1481:
1482: --Updating Balance Classifications
1483:
1484: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CLASSIFICATIONS',NULL);
1485: UPDATE hr_s_balance_classifications
1486: SET legislation_code = p_legislation_code
1487: WHERE legislation_code = 'ZZ';
1488:
1489: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',20);