APPS.PAY_CA_EOY_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 535: l_prev_person_id per_all_people_f.person_id%type;

531: /* Variables used to hold the current values returned within the loop for
532: checking against the new values returned from within the loop on the
533: next iteration. */
534:
535: l_prev_person_id per_all_people_f.person_id%type;
536: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
537:
538: /* Variable to hold the jurisdiction code used as a context for state
539: reporting. */

Line 1940: l_middle_names per_all_people_f.middle_names%TYPE;

1936: l_first_name varchar2(240);
1937: l_last_name varchar2(240);
1938: l_employee_number varchar2(240);
1939: l_national_identifier varchar2(240);
1940: l_middle_names per_all_people_f.middle_names%TYPE;
1941: l_employee_phone_no varchar2(240);
1942: l_address_line1 varchar2(240);
1943: l_address_line2 varchar2(240);
1944: l_address_line3 varchar2(240);

Line 2056: per_all_people_f PEOPLE

2052: ASSIGN.organization_id,
2053: ASSIGN.location_id
2054: FROM
2055: per_all_assignments_f ASSIGN,
2056: per_all_people_f PEOPLE
2057: WHERE ASSIGN.assignment_id = p_asgid
2058: and l_date_earned BETWEEN ASSIGN.effective_start_date
2059: AND ASSIGN.effective_end_date
2060: AND PEOPLE.person_id = ASSIGN.person_id

Line 2062: per_all_people_f PEOPLE1

2058: and l_date_earned BETWEEN ASSIGN.effective_start_date
2059: AND ASSIGN.effective_end_date
2060: AND PEOPLE.person_id = ASSIGN.person_id
2061: AND PEOPLE.effective_end_date = (select max(effective_end_date) from
2062: per_all_people_f PEOPLE1
2063: where PEOPLE1.person_id = PEOPLE.person_id);
2064:
2065: /* Get the jurisdiction code of all the cities
2066: for the person_id corresponding to the

Line 2218: per_all_people_f ppf,

2214: select paa.assignment_action_id,
2215: ppa.date_earned
2216: from pay_assignment_actions paa,
2217: per_all_assignments_f paf,
2218: per_all_people_f ppf,
2219: pay_payroll_actions ppa,
2220: pay_action_classifications pac,
2221: pay_action_contexts pac1,
2222: ff_contexts fc

Line 2247: from per_all_people_f ppf

2243: /* cursor to get date_of_birth for an employee to check EI and CPP Exempt */
2244: cursor c_get_date_of_birth(ln_person_id number
2245: ,ld_eff_date date) is
2246: select ppf.date_of_birth
2247: from per_all_people_f ppf
2248: where ppf.person_id = ln_person_id
2249: and ppf.effective_end_date = (select max(ppf2.effective_end_date)
2250: from per_all_people_f ppf2
2251: where ppf2.person_id= ln_person_id

Line 2250: from per_all_people_f ppf2

2246: select ppf.date_of_birth
2247: from per_all_people_f ppf
2248: where ppf.person_id = ln_person_id
2249: and ppf.effective_end_date = (select max(ppf2.effective_end_date)
2250: from per_all_people_f ppf2
2251: where ppf2.person_id= ln_person_id
2252: and ppf2.effective_start_date
2253: <= ld_eff_date);
2254: