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_ENTRIES_F

Line 28: ,pay_element_entries_f pee

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
32: AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date;

Line 84: FROM pay_element_entries_f pee

80: ,l_benefit_end_date DATE)
81: IS
82: SELECT pee.element_entry_id
83: ,pee.effective_start_date
84: FROM pay_element_entries_f pee
85: ,pay_element_entry_values_f peev1
86: ,pay_element_entry_values_f peev2
87: ,pay_element_entry_values_f peev3
88: WHERE pee.assignment_id = p_assignment_id

Line 121: FROM pay_element_entries_f pee

117: IS
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

Line 142: TYPE tab_element_entry_id IS TABLE OF pay_element_entries_f.element_entry_id%TYPE INDEX BY BINARY_INTEGER;

138:
139: TYPE tab_element_entry_value IS TABLE OF pay_element_entry_values_f.screen_entry_value%TYPE INDEX BY BINARY_INTEGER;
140: l_element_entry_value tab_element_entry_value;
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;

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

Line 896: FROM pay_element_entries_f pee

892: ,p_blk_input number
893: ,p_prev_block VARCHAR2)
894: IS
895: SELECT count(*)
896: FROM pay_element_entries_f pee
897: ,pay_element_entry_values_f peev1
898: ,pay_element_entry_values_f peev2
899: WHERE pee.assignment_id = p_assignment_id
900: AND pee.element_type_id = p_element_Type_id

Line 921: FROM pay_element_entries_f pee

917: ,p_blk_input NUMBER
918: ,p_curr_block VARCHAR2)
919: IS
920: SELECT count(*)
921: FROM pay_element_entries_f pee
922: ,pay_element_entry_values_f peev1
923: ,pay_element_entry_values_f peev2
924: WHERE pee.assignment_id = p_assignment_id
925: AND pee.element_type_id = p_element_Type_id