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.PQP_GB_AD_EE dependencies on PAY_ELEMENT_ENTRIES_F

Line 141: pay_element_entries_f pee,

137:
138: SELECT count(asg.assignment_id)
139: INTO l_asg_count
140: FROM pay_element_links_f pel,
141: pay_element_entries_f pee,
142: pay_element_types_f pet,
143: per_all_assignments_f asg,
144: pay_element_type_extra_info pete,
145: pay_element_entry_values_f peev,

Line 215: FROM pay_element_entries_f

211:
212: CURSOR c_eentry_efdate IS
213: SELECT effective_start_date,
214: effective_end_date
215: FROM pay_element_entries_f
216: WHERE element_entry_id=p_element_entry_id
217: AND p_effective_date BETWEEN
218: effective_start_date
219: AND effective_end_date;

Line 234: pay_element_entries_f pee,

230: pel.element_link_id,
231: pel.effective_end_date link_end_date,
232: pee.effective_start_date
233: FROM pay_element_links_f pel,
234: pay_element_entries_f pee,
235: pay_element_types_f pet,
236: pay_element_type_extra_info pete
237: WHERE pet.element_type_id = pel.element_type_id
238: AND pel.element_link_id = pee.element_link_id

Line 259: pay_element_entries_f pee,

255:
256: CURSOR chk_cur IS
257: SELECT 'x'
258: FROM pay_element_links_f pel,
259: pay_element_entries_f pee,
260: pay_element_types_f pet,
261: pay_element_type_extra_info pete
262: WHERE pet.element_type_id = pel.element_type_id
263: AND pel.element_link_id = pee.element_link_id

Line 284: pay_element_entries_f pee,

280: ,p_in_element_entry_id IN NUMBER
281: ) IS
282: SELECT peev.screen_entry_value
283: FROM pay_element_links_f pel,
284: pay_element_entries_f pee,
285: pay_element_types_f pet,
286: pay_element_type_extra_info pete,
287: pay_element_entry_values_f peev,
288: pay_input_values_f piv

Line 317: pay_element_entries_f pee,

313: CURSOR vehicle_type_cur(p_in_element_entry_id IN NUMBER
314: ) IS
315: SELECT peev.screen_entry_value
316: FROM pay_element_links_f pel,
317: pay_element_entries_f pee,
318: pay_element_types_f pet,
319: pay_element_type_extra_info pete,
320: pay_element_entry_values_f peev,
321: pay_input_values_f piv

Line 354: pay_element_entries_f pee,

350: ,p_in_element_entry_id IN NUMBER
351: ,p_in_end_date IN DATE) IS
352: SELECT peev.screen_entry_value
353: FROM pay_element_links_f pel,
354: pay_element_entries_f pee,
355: pay_element_types_f pet,
356: pay_element_type_extra_info pete,
357: pay_element_entry_values_f peev,
358: pay_input_values_f piv

Line 387: pay_element_entries_f pee,

383: CURSOR vehicle_type_cur1(p_in_element_entry_id IN NUMBER
384: ,p_in_end_date IN DATE) IS
385: SELECT peev.screen_entry_value
386: FROM pay_element_links_f pel,
387: pay_element_entries_f pee,
388: pay_element_types_f pet,
389: pay_element_type_extra_info pete,
390: pay_element_entry_values_f peev,
391: pay_input_values_f piv

Line 647: UPDATE pay_element_entries_f

643:
644: -- Cannot call the API as it can go in an infinite loop.
645: -- Manually update the effective_end_date to
646: -- the effective_end_date on the Element Link
647: UPDATE pay_element_entries_f
648: SET effective_end_date =
649: LEAST(temp_rec.link_end_date,l_asg_eff_ed)
650: WHERE element_entry_id = temp_rec.element_entry_id
651: AND effective_end_date = temp_rec.effective_end_date;

Line 733: FROM pay_element_entries_f pef

729:
730: CURSOR c_entry_exist (cp_link_id NUMBER)
731: IS
732: SELECT 'Y'
733: FROM pay_element_entries_f pef
734: WHERE pef.assignment_id = p_assignment_id
735: AND pef.element_link_id=cp_link_id
736: AND p_effective_date
737: BETWEEN pef.effective_start_date

Line 1015: FROM pay_element_entries_f

1011: --Cursor to fetch element type id's for Employee since he is Casual
1012: CURSOR csr_get_ele_type_since_casual(c_asg_start_date DATE)
1013: IS
1014: SELECT element_type_id
1015: FROM pay_element_entries_f
1016: WHERE assignment_id = p_assignment_id
1017: AND effective_start_date BETWEEN c_asg_start_date AND (p_effective_start_date-1)
1018: ORDER BY effective_start_date;
1019:

Line 1554: pay_element_entries_f peef,

1550: is
1551: select pap.per_information10 per_agg_flag
1552: from
1553: per_all_people_f pap,
1554: pay_element_entries_f peef,
1555: per_all_assignments_f paaf
1556: where
1557: peef.element_entry_id = p_element_entry_id
1558: and paaf.assignment_id = peef.assignment_id

Line 1757: pay_element_entries_f peef,

1753: is
1754: select pap.per_information10 per_agg_flag
1755: from
1756: per_all_people_f pap,
1757: pay_element_entries_f peef,
1758: per_all_assignments_f paaf
1759: where
1760: peef.element_entry_id = p_element_entry_id
1761: and paaf.assignment_id = peef.assignment_id

Line 2080: FROM pay_element_entries_f

2076: The query now retrieves the assignment id by taking into consideration p_effective_start_date instead of p_effective_date.
2077: */
2078: SELECT assignment_id
2079: INTO l_paye_assg_id
2080: FROM pay_element_entries_f
2081: WHERE element_entry_id = p_element_entry_id
2082: AND p_effective_start_date BETWEEN effective_start_date AND effective_end_date;
2083:
2084: --Fix for Bug 11924747 Ends here.