[Home] [Help]
95: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
96:
97: CURSOR get_balance_type_csr IS
98: SELECT distinct balance_type_id, currency_code, balance_name
99: FROM hr_s_balance_types pbt
100: ,hr_s_application_ownerships ao
101: ,fnd_product_installations b
102: ,fnd_application c
103: WHERE pbt.legislation_code = 'ZZ'
111:
112: CURSOR get_defined_balances_csr IS
113: SELECT distinct defined_balance_id, pbt.balance_name bname
114: FROM hr_s_defined_balances pdb
115: ,hr_s_balance_types pbt
116: ,hr_s_application_ownerships ao
117: ,fnd_product_installations b
118: ,fnd_application c
119: WHERE pdb.legislation_code ='ZZ'
172:
173: CURSOR get_balance_class_csr IS
174: SELECT distinct pbc.balance_classification_id, pbt.balance_name bname
175: FROM hr_s_balance_classifications pbc
176: ,hr_s_balance_types pbt
177: WHERE pbc.legislation_code ='ZZ'
178: AND pbc.balance_type_id = pbt.balance_type_id;
179:
180: BEGIN
189:
190: -- write output file for Balance Types to be Installed.
191:
192: write_log('OUTPUT',NULL,NULL,NULL);
193: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
194:
195: FOR rec IN get_balance_type_csr LOOP
196: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Balance Types', rec.balance_name);
197: END LOOP;
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);
491: DELETE hr_s_balance_types;
492: COMMIT;
493:
494: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);
487: COMMIT;
488: /*bug 10212578 End */
489:
490: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_TYPES',NULL);
491: DELETE hr_s_balance_types;
492: COMMIT;
493:
494: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);
495: DELETE hr_s_balance_classifications;
712: d.last_update_date, d.last_updated_by, d.last_update_login, d.created_by, d.creation_date,
713: d.object_version_number, d.grossup_allowed_flag, b.balance_name bname
714: FROM pay_defined_balances d, pay_balance_types b
715: WHERE d.balance_type_id = b.balance_type_id
716: AND EXISTS (SELECT NULL FROM hr_s_balance_types b
717: WHERE d.balance_type_id = b.balance_type_id);
718:
719:
720: --Cursors to install route and dimension if install_tax_unit is true.
942:
943: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables',20);
944: --Balance Types
945: write_log('LOG',NULL,NULL,NULL);
946: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
947: FOR rec IN get_balance_type_csr LOOP
948: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Types', rec.balance_name);
949:
950: INSERT INTO hr_s_balance_types
946: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Types', 'HR_S_BALANCE_TYPES');
947: FOR rec IN get_balance_type_csr LOOP
948: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Types', rec.balance_name);
949:
950: INSERT INTO hr_s_balance_types
951: ( balance_type_id
952: ,business_group_id
953: ,legislation_code
954: ,currency_code
1814: WHERE legislation_code = 'ZZ';
1815:
1816: --Updating Balance Types Table
1817:
1818: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_TYPES',NULL);
1819: UPDATE hr_s_BALANCE_TYPES
1820: SET legislation_code = p_legislation_code,
1821: currency_code = p_currency_code
1822: WHERE legislation_code = 'ZZ';
1815:
1816: --Updating Balance Types Table
1817:
1818: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_TYPES',NULL);
1819: UPDATE hr_s_BALANCE_TYPES
1820: SET legislation_code = p_legislation_code,
1821: currency_code = p_currency_code
1822: WHERE legislation_code = 'ZZ';
1823: