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_NO_TC_DP_UPLOAD dependencies on PAY_ELEMENT_LINKS_F

Line 73: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;

69: -- Variables to Read from File
70: l_ni VARCHAR2(80);
71: l_employer_org_no VARCHAR2(80);
72: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
73: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
74: l_element_name pay_element_types_f.element_name%TYPE;
75: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
76: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
77: l_input_value_name1 VARCHAR2(80);

Line 152: , pay_element_links_f pel

148: IS
149: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
150: from pay_element_entries_f pee
151: , pay_element_types_f pet
152: , pay_element_links_f pel
153: , per_all_assignments_f paa
154: where pet.ELEMENT_NAME = 'Tax Card'
155: and pet.legislation_code = 'NO'
156: and pel.ELEMENT_TYPE_ID = pet.ELEMENT_TYPE_ID

Line 994: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;

990: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE
991: ) RETURN NUMBER
992: IS
993:
994: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
995:
996: CURSOR csr_get_payroll_id IS
997: SELECT payroll_id
998: FROM per_all_assignments_f