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_ARCHIVE_LTFA dependencies on PER_ALL_ASSIGNMENTS

Line 607: ,per_all_assignments_f as1

603: ,pay_payroll_actions appa2
604: ,pay_assignment_actions act
605: ,pay_assignment_actions act1
606: ,pay_action_interlocks pai
607: ,per_all_assignments_f as1
608: ,hr_soft_coding_keyflex hsck
609: , per_all_people_f pap
610: WHERE ppa.payroll_action_id = p_payroll_action_id
611: AND appa.effective_date BETWEEN l_canonical_start_date

Line 658: per_all_assignments_f as1

654: pay_payroll_actions appa2,
655: pay_assignment_actions act,
656: pay_assignment_actions act1,
657: pay_action_interlocks pai,
658: per_all_assignments_f as1
659: , per_all_people_f pap
660: WHERE ppa.payroll_action_id = p_payroll_action_id
661: AND appa.effective_date BETWEEN l_canonical_start_date
662: AND l_canonical_end_date

Line 870: per_all_assignments assign,

866: CURSOR csr_get_person_details(p_asg_act_id NUMBER) IS
867: SELECT pap.first_name, pap.last_name, pap.pre_name_adjunct, pap.national_identifier , pap.person_id , pac.assignment_id
868: FROM
869: pay_assignment_actions pac,
870: per_all_assignments assign,
871: per_all_people pap
872: WHERE pac.assignment_action_id = p_asg_act_id
873: AND assign.assignment_id = pac.assignment_id
874: AND assign.person_id = pap.person_id