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.PER_IN_PERQUISITE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 27: FROM pay_element_types_f pet

23: CURSOR c_perquisite_name IS
24: SELECT pet.element_information1
25: ,pet.element_type_id
26: ,pee.assignment_id
27: FROM pay_element_types_f pet
28: ,pay_element_entries_f pee
29: WHERE pet.element_type_id =pee.element_type_id
30: AND pee.element_entry_id =p_element_entry_id
31: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 122: ,pay_element_types_f pet

118: SELECT pee.effective_start_date
119: ,pet.element_type_id
120: ,pee.assignment_id
121: FROM pay_element_entries_f pee
122: ,pay_element_types_f pet
123: ,pay_element_links_f links
124: WHERE pee.element_entry_id = p_element_entry_id
125: AND pet.element_type_id = links.element_type_id
126: AND links.element_link_id = pee.element_link_id

Line 145: TYPE tab_element_type_id IS TABLE OF pay_element_types_f.element_type_id%TYPE INDEX BY BINARY_INTEGER;

141:
142: TYPE tab_element_entry_id IS TABLE OF pay_element_entries_f.element_entry_id%TYPE INDEX BY BINARY_INTEGER;
143: l_element_entry_id tab_element_entry_id;
144:
145: TYPE tab_element_type_id IS TABLE OF pay_element_types_f.element_type_id%TYPE INDEX BY BINARY_INTEGER;
146: l_element_type_id_tab tab_element_type_id;
147:
148: l_entry_value_id NUMBER;
149: i NUMBER ;

Line 151: l_element_name pay_element_types_f.element_name %TYPE;

147:
148: l_entry_value_id NUMBER;
149: i NUMBER ;
150: l_exempted NUMBER;
151: l_element_name pay_element_types_f.element_name %TYPE;
152: l_element_type_id NUMBER;
153: l_assignment_id NUMBER;
154:
155:

Line 271: FROM pay_element_entries_f pee,pay_element_types_f pet

267: l_assignment_id NUMBER) IS
268:
269: CURSOR c_entries_start_tax_yr(p_tax_year_start DATE, p_assignment_id NUMBER, p_element_name varchar2) IS
270: SELECT pee.element_entry_id,pet.element_type_id
271: FROM pay_element_entries_f pee,pay_element_types_f pet
272: WHERE pee.assignment_id = p_assignment_id
273: AND pee.element_type_id = pet.element_type_id
274: AND pet.element_information1 = p_element_name
275: GROUP BY pee.element_entry_id,pet.element_type_id