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

Line 70: from per_all_people_f papf,

66: l_susp_assign per_assignment_status_types.per_system_status%TYPE;
67:
68: cursor csr_per_date is
69: select min(papf.effective_start_date)
70: from per_all_people_f papf,
71: per_person_types ppt
72: where papf.person_type_id = ppt.person_type_id
73: and system_person_type in (l_emp,l_emp_apl)
74: and papf.person_id = p_per_or_asg_id

Line 660: from per_all_people_f papf

656:
657: cursor csr_get_derived_details is
658: select bus.business_group_id
659: , bus.legislation_code
660: from per_all_people_f papf
661: , per_business_groups_perf bus
662: where papf.person_id = p_person_id
663: and l_effective_date between papf.effective_start_date
664: and papf.effective_end_date

Line 783: per_all_people_f pap,

779: cursor csr_contract_type is
780: select soft1.segment4 contract_type1, soft2.segment4 contract_type2
781: from hr_soft_coding_keyflex soft1,
782: per_all_assignments_f paf1,
783: per_all_people_f pap,
784: per_assignment_status_types pst,
785: hr_soft_coding_keyflex soft2,
786: per_all_assignments_f paf2
787: where pap.person_id = (select per_or_asg_id from pay_pl_sii_details_f