APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 983: l_prev_person_id per_all_people_f.person_id%type;

979: /* Variables used to hold the current values returned within the loop for
980: checking against the new values returned from within the loop on the
981: next iteration. */
982:
983: l_prev_person_id per_all_people_f.person_id%type;
984: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
985:
986: /* Variable to hold the jurisdiction code used as a context for state
987: reporting. */

Line 1114: per_all_people_f ppf,

1110: cp_period_end date) IS
1111: select paa.assignment_action_id
1112: from pay_assignment_actions paa,
1113: per_all_assignments_f paf,
1114: per_all_people_f ppf,
1115: pay_payroll_actions ppa,
1116: pay_action_classifications pac
1117: where ppf.person_id = cp_person_id
1118: and paf.person_id = ppf.person_id

Line 2341: per_all_people_f ppf,

2337: ) IS
2338: select paa.assignment_action_id
2339: from pay_assignment_actions paa,
2340: per_all_assignments_f paf,
2341: per_all_people_f ppf,
2342: pay_payroll_actions ppa,
2343: pay_action_classifications pac,
2344: pay_action_contexts pac1,
2345: ff_contexts fc

Line 2373: per_all_people_f ppf,

2369: cp_period_end date) IS
2370: select paa.assignment_action_id
2371: from pay_assignment_actions paa,
2372: per_all_assignments_f paf,
2373: per_all_people_f ppf,
2374: pay_payroll_actions ppa,
2375: pay_action_classifications pac
2376: where ppf.person_id = cp_person_id
2377: and paf.person_id = ppf.person_id

Line 3706: ,per_all_people_f PEOPLE

3702: l_national_identifier,
3703: l_pre_name_adjunct,
3704: l_employee_phone_no
3705: from per_all_assignments_f ASSIGN
3706: ,per_all_people_f PEOPLE
3707: ,per_person_types PTYPE
3708: ,per_phones PHONE
3709: ,fnd_sessions SES
3710: where l_date_earned BETWEEN ASSIGN.effective_start_date

Line 3718: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'

3714: and l_date_earned BETWEEN PEOPLE.effective_start_date
3715: AND PEOPLE.effective_end_date
3716: and PTYPE.person_type_id = PEOPLE.person_type_id
3717: and PHONE.parent_id (+) = PEOPLE.person_id
3718: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
3719: and PHONE.phone_type (+)= 'W1'
3720: and l_date_earned
3721: BETWEEN NVL(PHONE.date_from,l_date_earned)
3722: AND NVL(PHONE.date_to,l_date_earned)

Line 3743: ,per_all_people_f PEOPLE

3739: l_date_of_birth,
3740: l_national_identifier,
3741: l_pre_name_adjunct
3742: from per_all_assignments_f ASSIGN
3743: ,per_all_people_f PEOPLE
3744: where ASSIGN.assignment_id =l_asgid
3745: and PEOPLE.person_id = ASSIGN.person_id
3746: -- code fix started for 6440125
3747: and l_date_earned BETWEEN ASSIGN.effective_start_date