DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_ARCHIVE_PKG dependencies on PER_JOBS

Line 919: emp_ass_job_name per_jobs.name%type,

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,
921: emp_ass_location_name hr_locations.location_code%type,
922: emp_si_itax_org_id number,
923: emp_si_itax_type varchar2(60),

Line 7631: per_jobs_vl pjb,

7627: and ppos.period_of_service_id = pa.period_of_service_id
7628: and ppy.payroll_id = proc_v.payroll_id
7629: and proc_v.effective_date
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

Line 8144: per_jobs_vl pjb,

8140: and ppos.period_of_service_id = pa.period_of_service_id
8141: and ppy.payroll_id = proc_v.payroll_id
8142: and proc_v.effective_date
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

Line 8242: per_jobs_vl pjb,

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
8245: where padr.person_id (+) = v.person_id
8246: and padr.address_type (+) = 'JP_R'