APPS.PAY_US_ARCHIVE dependencies on PER_PEOPLE_F

Line 1138: l_prev_person_id per_people_f.person_id%type;

1134:
1135: /* Variables used to hold the current values returned within the loop for
1136: checking against the new values returned from within the loop on the
1137: next iteration. */
1138: l_prev_person_id per_people_f.person_id%type;
1139: l_prev_tax_unit_id hr_organization_units.organization_id%type;
1140:
1141: /* Variable to hold the jurisdiction code used as a context for state
1142: reporting. */

Line 2997: l_person_id per_people_f.person_id%type;

2993: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
2994: l_step number := 0;
2995: l_county_code varchar2(3);
2996: l_city_code varchar2(4);
2997: l_person_id per_people_f.person_id%type;
2998: l_jursd_context_id ff_contexts.context_id%type;
2999: l_user_entity_id_tab pay_us_archive.number_data_type_table;
3000: l_user_entity_tab pay_us_archive.char240_data_type_table;
3001: l_defined_balance_id_tab pay_us_archive.number_data_type_table;

Line 3016: l_marital_status per_people_f.marital_status%type;

3012: l_chk_county_archive varchar2(1);
3013: l_chk_cnt_sd_archive varchar2(1);
3014: l_chk_city_sd_archive varchar2(1);
3015: l_true varchar2(1);
3016: l_marital_status per_people_f.marital_status%type;
3017: l_con_national_identifier per_people_f.national_identifier%type;
3018: l_archive_item_id ff_archive_items.archive_item_id%type;
3019: l_object_version_number number(9);
3020: l_some_warning boolean;

Line 3017: l_con_national_identifier per_people_f.national_identifier%type;

3013: l_chk_cnt_sd_archive varchar2(1);
3014: l_chk_city_sd_archive varchar2(1);
3015: l_true varchar2(1);
3016: l_marital_status per_people_f.marital_status%type;
3017: l_con_national_identifier per_people_f.national_identifier%type;
3018: l_archive_item_id ff_archive_items.archive_item_id%type;
3019: l_object_version_number number(9);
3020: l_some_warning boolean;
3021: lv_value ff_archive_items.value%type := null;

Line 3972: from per_people_f ppf

3968: begin
3969:
3970: select ppf.marital_status
3971: into l_marital_status
3972: from per_people_f ppf
3973: where ppf.person_id = l_person_id
3974: and l_date_earned between ppf.effective_start_date
3975: and ppf.effective_end_date;
3976:

Line 3986: from per_people_f ppf,

3982: begin
3983:
3984: select ppf.national_identifier
3985: into l_con_national_identifier
3986: from per_people_f ppf,
3987: per_contact_relationships ctr
3988: where ctr.person_id = ppf.person_id
3989: and ctr.contact_person_id = l_person_id
3990: /* and ctr.personal_flag = 'Y'*/