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_NZ_SSCWT_RATE_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 24: g_element_type_id pay_element_types_f.element_type_id%TYPE ;

20: g_business_group_id per_people_f.business_group_id%TYPE;
21: g_financial_year DATE;
22: g_processing_mode VARCHAR2(1);
23:
24: g_element_type_id pay_element_types_f.element_type_id%TYPE ;
25: g_input_value_id pay_input_values_f.input_value_id%TYPE ;
26:
27: g_def_balance_tab pay_balance_pkg.t_balance_value_tab;
28:

Line 595: ,pay_element_types_f element

591: SELECT DISTINCT assignment.assignment_id
592: FROM per_people_f person
593: ,per_assignments_f assignment
594: ,per_periods_of_service service
595: ,pay_element_types_f element
596: ,pay_element_links_f link
597: ,pay_element_entries_f entry
598: WHERE person.person_id BETWEEN p_start_person
599: AND p_end_person

Line 758: FROM pay_element_types_f pet

754: --
755: CURSOR csr_get_element_ids(c_financial_year DATE)
756: IS
757: SELECT pet.element_type_id, piv.input_value_id
758: FROM pay_element_types_f pet
759: ,pay_input_values_f piv
760: WHERE pet.element_name = 'SSCWT Information'
761: AND pet.element_type_id = piv.element_type_id
762: AND piv.name = 'SSCWT Rate'