DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_LTFA dependencies on PER_ALL_PEOPLE

Line 609: , per_all_people_f pap

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
612: AND l_canonical_end_date
613: AND as1.person_id BETWEEN p_start_person

Line 659: , per_all_people_f pap

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
663: AND as1.person_id BETWEEN p_start_person

Line 871: per_all_people pap

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
875: AND pap.per_information_category = 'FI';