APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 911: emp_add_postal_code per_addresses.postal_code%type,

907: emp_sex per_all_people_f.sex%type,
908: emp_birth_date date,
909: emp_add_address_id number,
910: emp_add_address_jp varchar2(1),
911: emp_add_postal_code per_addresses.postal_code%type,
912: emp_add_district_code per_addresses.town_or_city%type,
913: emp_add_address varchar2(800),
914: emp_add_address_kana varchar2(800),
915: emp_add_phone1 per_addresses.telephone_number_1%type,

Line 912: emp_add_district_code per_addresses.town_or_city%type,

908: emp_birth_date date,
909: emp_add_address_id number,
910: emp_add_address_jp varchar2(1),
911: emp_add_postal_code per_addresses.postal_code%type,
912: emp_add_district_code per_addresses.town_or_city%type,
913: emp_add_address varchar2(800),
914: emp_add_address_kana varchar2(800),
915: emp_add_phone1 per_addresses.telephone_number_1%type,
916: emp_add_phone2 per_addresses.telephone_number_2%type,

Line 915: emp_add_phone1 per_addresses.telephone_number_1%type,

911: emp_add_postal_code per_addresses.postal_code%type,
912: emp_add_district_code per_addresses.town_or_city%type,
913: emp_add_address varchar2(800),
914: emp_add_address_kana varchar2(800),
915: emp_add_phone1 per_addresses.telephone_number_1%type,
916: emp_add_phone2 per_addresses.telephone_number_2%type,
917: emp_ass_hire_date date,
918: emp_ass_organization_name hr_all_organization_units.name%type,
919: emp_ass_job_name per_jobs.name%type,

Line 916: emp_add_phone2 per_addresses.telephone_number_2%type,

912: emp_add_district_code per_addresses.town_or_city%type,
913: emp_add_address varchar2(800),
914: emp_add_address_kana varchar2(800),
915: emp_add_phone1 per_addresses.telephone_number_1%type,
916: emp_add_phone2 per_addresses.telephone_number_2%type,
917: emp_ass_hire_date date,
918: emp_ass_organization_name hr_all_organization_units.name%type,
919: emp_ass_job_name per_jobs.name%type,
920: emp_ass_payroll_name pay_all_payrolls_f.payroll_name%type,

Line 7634: per_addresses padr,

7630: between ppy.effective_start_date and ppy.effective_end_date) v,
7631: per_jobs_vl pjb,
7632: hr_all_organization_units_vl hou,
7633: hr_locations_all_vl hlc,
7634: per_addresses padr,
7635: per_addresses padc
7636: where pjb.job_id (+) = v.job_id
7637: and v.effective_date
7638: between pjb.date_from (+) and nvl(pjb.date_to(+), hr_api.g_eot)

Line 7635: per_addresses padc

7631: per_jobs_vl pjb,
7632: hr_all_organization_units_vl hou,
7633: hr_locations_all_vl hlc,
7634: per_addresses padr,
7635: per_addresses padc
7636: where pjb.job_id (+) = v.job_id
7637: and v.effective_date
7638: between pjb.date_from (+) and nvl(pjb.date_to(+), hr_api.g_eot)
7639: and hou.organization_id (+) = v.organization_id

Line 8147: per_addresses padr,

8143: between ppy.effective_start_date and ppy.effective_end_date) v,
8144: per_jobs_vl pjb,
8145: hr_all_organization_units_vl hou,
8146: hr_locations_all_vl hlc,
8147: per_addresses padr,
8148: per_addresses padc
8149: where pjb.job_id (+) = v.job_id
8150: and v.effective_date
8151: between pjb.date_from (+) and nvl(pjb.date_to (+), hr_api.g_eot)

Line 8148: per_addresses padc

8144: per_jobs_vl pjb,
8145: hr_all_organization_units_vl hou,
8146: hr_locations_all_vl hlc,
8147: per_addresses padr,
8148: per_addresses padc
8149: where pjb.job_id (+) = v.job_id
8150: and v.effective_date
8151: between pjb.date_from (+) and nvl(pjb.date_to (+), hr_api.g_eot)
8152: and hou.organization_id (+) = v.organization_id

Line 8239: per_addresses padr,

8235: and pp.person_id = pa.person_id
8236: and p_effective_date
8237: between pp.effective_start_date and pp.effective_end_date
8238: and ppos.period_of_service_id = pa.period_of_service_id) v,
8239: per_addresses padr,
8240: per_addresses padc,
8241: pay_all_payrolls_f ppy,
8242: per_jobs_vl pjb,
8243: hr_all_organization_units_vl hou,

Line 8240: per_addresses padc,

8236: and p_effective_date
8237: between pp.effective_start_date and pp.effective_end_date
8238: and ppos.period_of_service_id = pa.period_of_service_id) v,
8239: per_addresses padr,
8240: per_addresses padc,
8241: pay_all_payrolls_f ppy,
8242: per_jobs_vl pjb,
8243: hr_all_organization_units_vl hou,
8244: hr_locations_all_vl hlc