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_TYPES_F

Line 74: l_element_name pay_element_types_f.element_name%TYPE;

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);
78: l_input_value_name2 VARCHAR2(80);

Line 151: , pay_element_types_f pet

147: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE )
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'

Line 990: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE

986: (
987: p_assignment_id IN NUMBER
988: ,p_business_group_id IN NUMBER
989: ,p_effective_date IN VARCHAR2
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;