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_SE_HOLIDAY_PAY dependencies on PER_ALL_PEOPLE_F

Line 107: -- ,per_all_people_f per

103: IS
104: SELECT DISTINCT eev1.screen_entry_value attendance_type_id
105: FROM per_all_assignments_f asg1
106: --,per_all_assignments_f asg2
107: -- ,per_all_people_f per
108: , pay_element_links_f el
109: ,pay_element_types_f et
110: ,pay_input_values_f iv1
111: ,pay_element_entries_f ee

Line 196: ,per_all_people_f papf

192: ,papf.person_id
193: INTO l_business_group_id
194: ,l_person_id
195: FROM per_all_assignments_f paaf
196: ,per_all_people_f papf
197: ,hr_soft_coding_keyflex hsck
198: WHERE paaf.assignment_id = p_assignment_id
199: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
200: AND papf.person_id = paaf.person_id

Line 347: ,per_all_people_f papf

343: BEGIN
344: SELECT papf.business_group_id
345: INTO l_business_group_id
346: FROM per_all_assignments_f paaf
347: ,per_all_people_f papf
348: ,hr_soft_coding_keyflex hsck
349: WHERE paaf.assignment_id = p_assignment_id
350: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
351: AND papf.person_id = paaf.person_id

Line 532: -- ,per_all_people_f per

528: IS
529: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
530: FROM per_all_assignments_f asg1
531: --,per_all_assignments_f asg2
532: -- ,per_all_people_f per
533: , pay_element_links_f el
534: ,pay_element_types_f et
535: ,pay_input_values_f iv1
536: ,pay_element_entries_f ee

Line 625: ,per_all_people_f papf

621: INTO l_business_group_id
622: ,l_person_id
623: ,l_working_perc
624: FROM per_all_assignments_f paaf
625: ,per_all_people_f papf
626: ,hr_soft_coding_keyflex hsck
627: WHERE paaf.assignment_id = p_assignment_id --15381
628: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
629: AND papf.person_id = paaf.person_id

Line 914: ,per_all_people_f papf

910: ,papf.person_id
911: INTO l_business_group_id
912: ,l_person_id
913: FROM per_all_assignments_f paaf
914: ,per_all_people_f papf
915: ,hr_soft_coding_keyflex hsck
916: WHERE paaf.assignment_id = p_assignment_id --15381
917: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
918: AND papf.person_id = paaf.person_id

Line 1197: ,per_all_people_f papf

1193: ,papf.person_id
1194: INTO l_business_group_id
1195: ,l_person_id
1196: FROM per_all_assignments_f paaf
1197: ,per_all_people_f papf
1198: ,hr_soft_coding_keyflex hsck
1199: WHERE paaf.assignment_id = p_assignment_id --15381
1200: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1201: AND papf.person_id = paaf.person_id

Line 1711: -- ,per_all_people_f per

1707: IS
1708: SELECT DISTINCT eev1.screen_entry_value attendance_category_id
1709: FROM per_all_assignments_f asg1
1710: --,per_all_assignments_f asg2
1711: -- ,per_all_people_f per
1712: , pay_element_links_f el
1713: ,pay_element_types_f et
1714: ,pay_input_values_f iv1
1715: ,pay_element_entries_f ee

Line 1850: ,per_all_people_f papf

1846: INTO l_business_group_id
1847: ,l_person_id
1848: ,l_working_perc
1849: FROM per_all_assignments_f paaf
1850: ,per_all_people_f papf
1851: ,hr_soft_coding_keyflex hsck
1852: WHERE paaf.assignment_id = p_assignment_id --15381
1853: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1854: AND papf.person_id = paaf.person_id

Line 2438: ,per_all_people_f papf

2434: IS
2435: SELECT papf.business_group_id
2436: ,papf.person_id
2437: FROM per_all_assignments_f paaf
2438: ,per_all_people_f papf
2439: ,hr_soft_coding_keyflex hsck
2440: WHERE paaf.assignment_id = p_assignment_id --15381
2441: --AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
2442: AND papf.person_id = paaf.person_id

Line 2620: ,per_all_people_f papf

2616: INTO l_business_group_id
2617: ,l_person_id
2618: ,l_working_perc
2619: FROM per_all_assignments_f paaf
2620: ,per_all_people_f papf
2621: ,hr_soft_coding_keyflex hsck
2622: WHERE paaf.assignment_id = p_assignment_id
2623: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2624: AND papf.person_id = paaf.person_id

Line 2914: -- per_all_people_f papf,

2910: (fnd_number.canonical_to_number (segment13)),l_full_time)
2911: /* change this to the field which we are going to add for part time employee */
2912: FROM per_all_assignments_f paaf
2913: ,
2914: -- per_all_people_f papf,
2915: hr_soft_coding_keyflex hsck
2916: WHERE paaf.assignment_id = csr_v_assignment_id --15381
2917: AND paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
2918: --AND papf.person_id=paaf.person_id

Line 3168: ,per_all_people_f papf

3164: CURSOR csr_get_dob
3165: IS
3166: SELECT TRUNC (MONTHS_BETWEEN (p_effective_date, papf.date_of_birth))
3167: FROM per_all_assignments_f paaf
3168: ,per_all_people_f papf
3169: WHERE paaf.assignment_id = p_assignment_id
3170: AND papf.person_id = paaf.person_id
3171: AND p_effective_date BETWEEN paaf.effective_start_date
3172: AND paaf.effective_end_date