eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_ELEMENT_CLASSIFICATIONS

Line 84: FROM hr_s_element_classifications pec

80: PROCEDURE write_out IS
81:
82: CURSOR get_element_class_csr IS
83: SELECT distinct classification_id, legislation_code, classification_name
84: FROM hr_s_element_classifications pec
85: ,hr_s_application_ownerships ao
86: ,fnd_product_installations b
87: ,fnd_application c
88: WHERE nvl(legislation_code,'X') = 'ZZ'

Line 184: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Element Classifications', 'HR_S_ELEMENT_CLASSIFICATIONS');

180: BEGIN
181:
182: -- write output file for Element Classifications to be Installed.
183: write_log('OUTPUT',NULL,NULL,NULL);
184: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Element Classifications', 'HR_S_ELEMENT_CLASSIFICATIONS');
185:
186: FOR rec IN get_element_class_csr LOOP
187: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Element Classification', rec.classification_name);
188: END LOOP;

Line 460: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_CLASSIFICATIONS',NULL);

456: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ASSIGNMENT_STATUS_TYPES',NULL);
457: DELETE hr_s_assignment_status_types;
458: COMMIT;
459:
460: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
461: DELETE hr_s_element_classifications;
462: COMMIT;
463:
464: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_TYPES_F',NULL);

Line 461: DELETE hr_s_element_classifications;

457: DELETE hr_s_assignment_status_types;
458: COMMIT;
459:
460: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
461: DELETE hr_s_element_classifications;
462: COMMIT;
463:
464: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_TYPES_F',NULL);
465: DELETE hr_s_element_types_f;

Line 882: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Element Classifications', 'HR_S_ELEMENT_CLASSIFICATIONS');

878:
879: -- Element Classifictions
880:
881: write_log('LOG',NULL,NULL,NULL);
882: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Element Classifications', 'HR_S_ELEMENT_CLASSIFICATIONS');
883:
884: FOR rec IN get_element_class_csr LOOP
885: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Element Classification', rec.classification_name);
886:

Line 887: INSERT INTO hr_s_element_classifications

883:
884: FOR rec IN get_element_class_csr LOOP
885: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Element Classification', rec.classification_name);
886:
887: INSERT INTO hr_s_element_classifications
888: ( classification_id
889: ,business_group_id
890: ,legislation_code
891: ,classification_name

Line 1811: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);

1807: BEGIN
1808: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);
1809: --Updating Element Classifications Table
1810:
1811: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
1812: UPDATE hr_s_element_classifications
1813: SET legislation_code = p_legislation_code
1814: WHERE legislation_code = 'ZZ';
1815:

Line 1812: UPDATE hr_s_element_classifications

1808: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);
1809: --Updating Element Classifications Table
1810:
1811: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
1812: UPDATE hr_s_element_classifications
1813: SET legislation_code = p_legislation_code
1814: WHERE legislation_code = 'ZZ';
1815:
1816: --Updating Balance Types Table