[Home] [Help]
89: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
90:
91: CURSOR get_balance_type_csr IS
92: SELECT distinct balance_type_id, currency_code, balance_name
93: FROM hr_s_balance_types pbt
94: ,hr_s_application_ownerships ao
95: ,fnd_product_installations b
96: ,fnd_application c
97: WHERE pbt.legislation_code = 'ZZ'
105:
106: CURSOR get_defined_balances_csr IS
107: SELECT distinct defined_balance_id, pbt.balance_name bname
108: FROM hr_s_defined_balances pdb
109: ,hr_s_balance_types pbt
110: ,hr_s_application_ownerships ao
111: ,fnd_product_installations b
112: ,fnd_application c
113: WHERE pdb.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:
174: BEGIN
183:
184: -- write output file for Balance Types to be Installed.
185:
186: write_log('OUTPUT',NULL,NULL,NULL);
187: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
188:
189: FOR rec IN get_balance_type_csr LOOP
190: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Balance Types', rec.balance_name);
191: END LOOP;
428: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_SUB_CLASSN_RULES_F',NULL);
429: DELETE hr_s_sub_classn_rules_f;
430: COMMIT;
431:
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);
429: DELETE hr_s_sub_classn_rules_f;
430: COMMIT;
431:
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;
650: d.last_update_date, d.last_updated_by, d.last_update_login, d.created_by, d.creation_date,
651: d.object_version_number, d.grossup_allowed_flag, b.balance_name bname
652: FROM pay_defined_balances d, pay_balance_types b
653: WHERE d.balance_type_id = b.balance_type_id
654: AND EXISTS (SELECT NULL FROM hr_s_balance_types b
655: WHERE d.balance_type_id = b.balance_type_id);
656:
657:
658: --Cursors to install route and dimension if install_tax_unit is true.
813:
814: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables',20);
815: --Balance Types
816: write_log('LOG',NULL,NULL,NULL);
817: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
818: FOR rec IN get_balance_type_csr LOOP
819: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Types', rec.balance_name);
820:
821: INSERT INTO hr_s_balance_types
817: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
818: FOR rec IN get_balance_type_csr LOOP
819: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Types', rec.balance_name);
820:
821: INSERT INTO hr_s_balance_types
822: ( balance_type_id
823: ,business_group_id
824: ,legislation_code
825: ,currency_code
1443: WHERE legislation_code = 'ZZ';
1444:
1445: --Updating Balance Types Table
1446:
1447: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_TYPES',NULL);
1448: UPDATE hr_s_BALANCE_TYPES
1449: SET legislation_code = p_legislation_code,
1450: currency_code = p_currency_code
1451: WHERE legislation_code = 'ZZ';
1444:
1445: --Updating Balance Types Table
1446:
1447: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_TYPES',NULL);
1448: UPDATE hr_s_BALANCE_TYPES
1449: SET legislation_code = p_legislation_code,
1450: currency_code = p_currency_code
1451: WHERE legislation_code = 'ZZ';
1452: