APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1071: l_prev_person_id per_all_people_f.person_id%type;

1067: /* Variables used to hold the current values returned within the loop for
1068: checking against the new values returned from within the loop on the
1069: next iteration. */
1070:
1071: l_prev_person_id per_all_people_f.person_id%type;
1072: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
1073:
1074: /* Variable to hold the jurisdiction code used as a context for state
1075: reporting. */

Line 1250: per_all_people_f ppf,

1246: cp_period_end date) IS
1247: select paa.assignment_action_id
1248: from pay_assignment_actions paa,
1249: per_all_assignments_f paf,
1250: per_all_people_f ppf,
1251: pay_payroll_actions ppa,
1252: pay_action_classifications pac
1253: where ppf.person_id = cp_person_id
1254: and paf.person_id = ppf.person_id

Line 2468: from per_all_people_f ppf,

2464: cp_period_start date,
2465: cp_period_end date
2466: ) IS
2467: select /*+ Ordered */ paa.assignment_action_id
2468: from per_all_people_f ppf,
2469: per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,

Line 3184: from per_all_people_f ppf,

3180: cp_period_start date,
3181: cp_period_end date
3182: ) IS
3183: select /*+ Ordered */ paa.assignment_action_id
3184: from per_all_people_f ppf,
3185: per_all_assignments_f paf,
3186: pay_assignment_actions paa,
3187: pay_payroll_actions ppa,
3188: pay_action_classifications pac,

Line 3218: per_all_people_f ppf,

3214: cp_period_end date) IS
3215: select paa.assignment_action_id
3216: from pay_assignment_actions paa,
3217: per_all_assignments_f paf,
3218: per_all_people_f ppf,
3219: pay_payroll_actions ppa,
3220: pay_action_classifications pac
3221: where ppf.person_id = cp_person_id
3222: and paf.person_id = ppf.person_id

Line 4725: ,per_all_people_f PEOPLE

4721: l_national_identifier,
4722: l_pre_name_adjunct,
4723: l_employee_phone_no
4724: from per_all_assignments_f ASSIGN
4725: ,per_all_people_f PEOPLE
4726: ,per_person_types PTYPE
4727: ,per_phones PHONE
4728: ,fnd_sessions SES
4729: where l_date_earned BETWEEN ASSIGN.effective_start_date

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

4733: and l_date_earned BETWEEN PEOPLE.effective_start_date
4734: AND PEOPLE.effective_end_date
4735: and PTYPE.person_type_id = PEOPLE.person_type_id
4736: and PHONE.parent_id (+) = PEOPLE.person_id
4737: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
4738: and PHONE.phone_type (+)= 'W1'
4739: and l_date_earned
4740: BETWEEN NVL(PHONE.date_from,l_date_earned)
4741: AND NVL(PHONE.date_to,l_date_earned)

Line 4762: ,per_all_people_f PEOPLE

4758: l_date_of_birth,
4759: l_national_identifier,
4760: l_pre_name_adjunct
4761: from per_all_assignments_f ASSIGN
4762: ,per_all_people_f PEOPLE
4763: where ASSIGN.assignment_id =l_asgid
4764: and PEOPLE.person_id = ASSIGN.person_id
4765: -- code fix started for 6440125
4766: and l_date_earned BETWEEN ASSIGN.effective_start_date