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_ENTRIES_F

Line 72: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

68:
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;

Line 75: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

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);
79: l_input_value_name3 VARCHAR2(80);

Line 76: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

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);
79: l_input_value_name3 VARCHAR2(80);
80: l_input_value_name4 VARCHAR2(80);

Line 150: from pay_element_entries_f pee

146:
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'