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 78: FROM hr_s_element_classifications pec

74: PROCEDURE write_out IS
75:
76: CURSOR get_element_class_csr IS
77: SELECT distinct classification_id, legislation_code, classification_name
78: FROM hr_s_element_classifications pec
79: ,hr_s_application_ownerships ao
80: ,fnd_product_installations b
81: ,fnd_application c
82: WHERE nvl(legislation_code,'X') = 'ZZ'

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

174: BEGIN
175:
176: -- write output file for Element Classifications to be Installed.
177: write_log('OUTPUT',NULL,NULL,NULL);
178: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Element Classifications', 'HR_S_ELEMENT_CLASSIFICATIONS');
179:
180: FOR rec IN get_element_class_csr LOOP
181: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Element Classification', rec.classification_name);
182: END LOOP;

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

404: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ASSIGNMENT_STATUS_TYPES',NULL);
405: DELETE hr_s_assignment_status_types;
406: COMMIT;
407:
408: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
409: DELETE hr_s_element_classifications;
410: COMMIT;
411:
412: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_TYPES_F',NULL);

Line 409: DELETE hr_s_element_classifications;

405: DELETE hr_s_assignment_status_types;
406: COMMIT;
407:
408: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
409: DELETE hr_s_element_classifications;
410: COMMIT;
411:
412: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_ELEMENT_TYPES_F',NULL);
413: DELETE hr_s_element_types_f;

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

749:
750: -- Element Classifictions
751:
752: write_log('LOG',NULL,NULL,NULL);
753: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Element Classifications', 'HR_S_ELEMENT_CLASSIFICATIONS');
754:
755: FOR rec IN get_element_class_csr LOOP
756: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Element Classification', rec.classification_name);
757:

Line 758: INSERT INTO hr_s_element_classifications

754:
755: FOR rec IN get_element_class_csr LOOP
756: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Element Classification', rec.classification_name);
757:
758: INSERT INTO hr_s_element_classifications
759: ( classification_id
760: ,business_group_id
761: ,legislation_code
762: ,classification_name

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

1436: BEGIN
1437: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);
1438: --Updating Element Classifications Table
1439:
1440: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
1441: UPDATE hr_s_element_classifications
1442: SET legislation_code = p_legislation_code
1443: WHERE legislation_code = 'ZZ';
1444:

Line 1441: UPDATE hr_s_element_classifications

1437: hr_utility.set_location('pay_ip_startup_util.update_shadow_tables ',10);
1438: --Updating Element Classifications Table
1439:
1440: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_ELEMENT_CLASSIFICATIONS',NULL);
1441: UPDATE hr_s_element_classifications
1442: SET legislation_code = p_legislation_code
1443: WHERE legislation_code = 'ZZ';
1444:
1445: --Updating Balance Types Table