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

Line 690: ,per_all_people_f per

686: SELECT TO_NUMBER(TO_CHAR(ee.effective_start_date, 'J')) julian_effective_date
687: ,eev1.screen_entry_value screen_entry_value
688: FROM per_all_assignments_f asg1
689: ,per_all_assignments_f asg2
690: ,per_all_people_f per
691: ,pay_element_links_f el
692: ,pay_element_types_f et
693: ,pay_input_values_f iv1
694: ,pay_element_entries_f ee

Line 778: ,per_all_people_f per

774: CURSOR get_details(p_assignment_id NUMBER,p_effective_date DATE , p_input_value VARCHAR2 ) IS
775: SELECT eev1.screen_entry_value tax_days
776: FROM per_all_assignments_f asg1
777: ,per_all_assignments_f asg2
778: ,per_all_people_f per
779: ,pay_element_links_f el
780: ,pay_element_types_f et
781: ,pay_input_values_f iv1
782: ,pay_element_entries_f ee

Line 904: ,per_all_people_f per

900:
901: CURSOR get_tax_details(p_assignment_id NUMBER , p_effective_date DATE) IS
902: SELECT TO_NUMBER(TO_CHAR(ee.effective_start_date, 'J')) julian_effective_date
903: FROM per_all_assignments_f asg1
904: ,per_all_people_f per
905: ,pay_element_links_f el
906: ,pay_element_types_f et
907: ,pay_element_entries_f ee
908: WHERE asg1.assignment_id = p_assignment_id

Line 1184: ,per_all_people_f per

1180:
1181: CURSOR c_person_pension_num(p_assignment_id NUMBER , p_effective_date DATE) IS
1182: SELECT PER_INFORMATION15, PER_INFORMATION16, PER_INFORMATION24
1183: FROM per_all_assignments_f asg1
1184: ,per_all_people_f per
1185: WHERE asg1.assignment_id = p_assignment_id
1186: AND per.person_id = asg1.person_id
1187: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1188: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date

Line 1277: ,per_all_people_f per

1273:
1274: CURSOR c_retire_date IS
1275: SELECT PER_INFORMATION8
1276: FROM per_all_assignments_f asg1
1277: ,per_all_people_f per
1278: WHERE asg1.assignment_id = p_assignment_id
1279: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
1280: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
1281: AND per.person_id = asg1.person_id;