APPS.PAY_US_ARCHIVE dependencies on PER_PEOPLE_F

Line 1442: l_prev_person_id per_people_f.person_id%type;

1438:
1439: /* Variables used to hold the current values returned within the loop for
1440: checking against the new values returned from within the loop on the
1441: next iteration. */
1442: l_prev_person_id per_people_f.person_id%type;
1443: l_prev_tax_unit_id hr_organization_units.organization_id%type;
1444:
1445: /* Variable to hold the jurisdiction code used as a context for state
1446: reporting. */

Line 3569: l_person_id per_people_f.person_id%type;

3565: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
3566: l_step number := 0;
3567: l_county_code varchar2(3);
3568: l_city_code varchar2(4);
3569: l_person_id per_people_f.person_id%type;
3570: l_jursd_context_id ff_contexts.context_id%type;
3571: l_user_entity_id_tab pay_us_archive.number_data_type_table;
3572: l_user_entity_tab pay_us_archive.char240_data_type_table;
3573: l_defined_balance_id_tab pay_us_archive.number_data_type_table;

Line 3588: l_marital_status per_people_f.marital_status%type;

3584: l_chk_county_archive varchar2(1);
3585: l_chk_cnt_sd_archive varchar2(1);
3586: l_chk_city_sd_archive varchar2(1);
3587: l_true varchar2(1);
3588: l_marital_status per_people_f.marital_status%type;
3589: l_con_national_identifier per_people_f.national_identifier%type;
3590: l_archive_item_id ff_archive_items.archive_item_id%type;
3591: l_object_version_number number(9);
3592: l_some_warning boolean;

Line 3589: l_con_national_identifier per_people_f.national_identifier%type;

3585: l_chk_cnt_sd_archive varchar2(1);
3586: l_chk_city_sd_archive varchar2(1);
3587: l_true varchar2(1);
3588: l_marital_status per_people_f.marital_status%type;
3589: l_con_national_identifier per_people_f.national_identifier%type;
3590: l_archive_item_id ff_archive_items.archive_item_id%type;
3591: l_object_version_number number(9);
3592: l_some_warning boolean;
3593: lv_value ff_archive_items.value%type := null;

Line 4636: from per_people_f ppf

4632: begin
4633:
4634: select ppf.marital_status
4635: into l_marital_status
4636: from per_people_f ppf
4637: where ppf.person_id = l_person_id
4638: and l_date_earned between ppf.effective_start_date
4639: and ppf.effective_end_date;
4640:

Line 4650: from per_people_f ppf,

4646: begin
4647:
4648: select ppf.national_identifier
4649: into l_con_national_identifier
4650: from per_people_f ppf,
4651: per_contact_relationships ctr
4652: where ctr.person_id = ppf.person_id
4653: and ctr.contact_person_id = l_person_id
4654: /* and ctr.personal_flag = 'Y'*/