APPS.PAY_CA_EOY_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 602: l_prev_person_id per_all_people_f.person_id%type;

598: /* Variables used to hold the current values returned within the loop for
599: checking against the new values returned from within the loop on the
600: next iteration. */
601:
602: l_prev_person_id per_all_people_f.person_id%type;
603: l_prev_tax_unit_id hr_all_organization_units.organization_id%type;
604:
605: /* Variable to hold the jurisdiction code used as a context for state
606: reporting. */

Line 2158: l_middle_names per_all_people_f.middle_names%TYPE;

2154: l_first_name varchar2(240);
2155: l_last_name varchar2(240);
2156: l_employee_number varchar2(240);
2157: l_national_identifier varchar2(240);
2158: l_middle_names per_all_people_f.middle_names%TYPE;
2159: l_employee_phone_no varchar2(240);
2160: l_address_line1 varchar2(240);
2161: l_address_line2 varchar2(240);
2162: l_address_line3 varchar2(240);

Line 2276: l_each_person_id per_all_people_f.person_id%type;

2272:
2273: -- l_screen_entry_value added by sneelapa for bug 6399498
2274: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%type;
2275:
2276: l_each_person_id per_all_people_f.person_id%type;
2277: l_each_asgid per_assignments_f.assignment_id%type;
2278:
2279: -- added for bug 10244185
2280: lv_code87_Maxlimit varchar2(30);

Line 2297: per_all_people_f PEOPLE

2293: ASSIGN.organization_id,
2294: ASSIGN.location_id
2295: FROM
2296: per_all_assignments_f ASSIGN,
2297: per_all_people_f PEOPLE
2298: WHERE ASSIGN.assignment_id = p_asgid
2299: and l_date_earned BETWEEN ASSIGN.effective_start_date
2300: AND ASSIGN.effective_end_date
2301: AND PEOPLE.person_id = ASSIGN.person_id

Line 2303: per_all_people_f PEOPLE1

2299: and l_date_earned BETWEEN ASSIGN.effective_start_date
2300: AND ASSIGN.effective_end_date
2301: AND PEOPLE.person_id = ASSIGN.person_id
2302: AND PEOPLE.effective_end_date = (select max(effective_end_date) from
2303: per_all_people_f PEOPLE1
2304: where PEOPLE1.person_id = PEOPLE.person_id);
2305:
2306: /* Get the jurisdiction code of all the cities
2307: for the person_id corresponding to the

Line 2413: ,per_all_people_f ppf

2409: -- perticular person in the same GRE
2410: cursor c_diff_assignments(p_person_id number) is
2411: select distinct(paf.assignment_id)
2412: from per_all_assignments_f paf
2413: ,per_all_people_f ppf
2414: ,hr_soft_coding_keyflex_kfv hsc
2415: ,hr_locations_all hl
2416: where ppf.person_id = p_person_id
2417: and ppf.person_id = paf.person_id

Line 2507: per_all_people_f ppf,

2503: select paa.assignment_action_id,
2504: ppa.date_earned
2505: from pay_assignment_actions paa,
2506: per_all_assignments_f paf,
2507: per_all_people_f ppf,
2508: pay_payroll_actions ppa,
2509: pay_action_classifications pac,
2510: pay_action_contexts pac1,
2511: ff_contexts fc

Line 2536: from per_all_people_f ppf

2532: /* cursor to get date_of_birth for an employee to check EI and CPP Exempt */
2533: cursor c_get_date_of_birth(ln_person_id number
2534: ,ld_eff_date date) is
2535: select ppf.date_of_birth
2536: from per_all_people_f ppf
2537: where ppf.person_id = ln_person_id
2538: and ppf.effective_end_date = (select max(ppf2.effective_end_date)
2539: from per_all_people_f ppf2
2540: where ppf2.person_id= ln_person_id

Line 2539: from per_all_people_f ppf2

2535: select ppf.date_of_birth
2536: from per_all_people_f ppf
2537: where ppf.person_id = ln_person_id
2538: and ppf.effective_end_date = (select max(ppf2.effective_end_date)
2539: from per_all_people_f ppf2
2540: where ppf2.person_id= ln_person_id
2541: and ppf2.effective_start_date
2542: <= ld_eff_date);
2543: