APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 931: l_prev_person_id per_all_people_f.person_id%type;

927: /* Variables used to hold the current values returned within the loop for
928: checking against the new values returned from within the loop on the
929: next iteration. */
930:
931: l_prev_person_id per_all_people_f.person_id%type;
932: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
933:
934: /* Variable to hold the jurisdiction code used as a context for state
935: reporting. */

Line 1109: per_all_people_f ppf,

1105: cp_period_end date) IS
1106: select paa.assignment_action_id
1107: from pay_assignment_actions paa,
1108: per_all_assignments_f paf,
1109: per_all_people_f ppf,
1110: pay_payroll_actions ppa,
1111: pay_action_classifications pac
1112: where ppf.person_id = cp_person_id
1113: and paf.person_id = ppf.person_id

Line 2155: per_all_people_f ppf,

2151: cp_period_end date) IS
2152: select paa.assignment_action_id
2153: from pay_assignment_actions paa,
2154: per_all_assignments_f paf,
2155: per_all_people_f ppf,
2156: pay_payroll_actions ppa,
2157: pay_action_classifications pac,
2158: pay_action_contexts pac1,
2159: ff_contexts fc

Line 2719: ,per_all_people_f PEOPLE

2715: PEOPLE.date_of_birth,
2716: replace(PEOPLE.national_identifier,' '),
2717: PEOPLE.pre_name_adjunct
2718: from per_all_assignments_f ASSIGN
2719: ,per_all_people_f PEOPLE
2720: where ASSIGN.assignment_id = cp_asg_id
2721: and PEOPLE.person_id = ASSIGN.person_id
2722: and PEOPLE.effective_end_date =
2723: (select max(effective_end_date)

Line 2724: from per_all_people_f PEOPLE1

2720: where ASSIGN.assignment_id = cp_asg_id
2721: and PEOPLE.person_id = ASSIGN.person_id
2722: and PEOPLE.effective_end_date =
2723: (select max(effective_end_date)
2724: from per_all_people_f PEOPLE1
2725: where PEOPLE1.person_id = PEOPLE.person_id);
2726:
2727:
2728: /* Query to get the max asg_act_id for a payroll run in a given year

Line 2738: per_all_people_f ppf,

2734: cp_period_end date) IS
2735: select paa.assignment_action_id
2736: from pay_assignment_actions paa,
2737: per_all_assignments_f paf,
2738: per_all_people_f ppf,
2739: pay_payroll_actions ppa,
2740: pay_action_classifications pac,
2741: pay_action_contexts pac1,
2742: ff_contexts fc

Line 3715: from per_all_people_f ppf

3711: select ppf.full_name,
3712: replace(ppf.national_identifier,' ')
3713: into l_beneficiary_name,
3714: l_beneficiary_sin
3715: from per_all_people_f ppf
3716: where ppf.person_id = to_number(l_per_eit_beneficiary_id);
3717:
3718: exception when no_data_found then
3719: l_beneficiary_name := null;