DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on HR_ORGANIZATION_UNITS

Line 422: , hr_organization_units hou

418: FROM per_all_assignments_f paf
419: , per_all_people_f ppf
420: , per_periods_of_service pps
421: , per_jobs pj
422: , hr_organization_units hou
423: , pay_payrolls_f prl
424: WHERE paf.person_id = ppf.person_id
425: and paf.assignment_id = p_assignment_id
426: AND paf.job_id = pj.job_id(+)

Line 528: l_employer hr_organization_units.name%TYPE;

524: l_assignment_id NUMBER;
525: l_effective_date DATE;
526: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
527: l_job per_jobs.name%TYPE;
528: l_employer hr_organization_units.name%TYPE;
529: l_payroll_id NUMBER;
530: l_asg_num NUMBER;
531: l_det_org_pay_method NUMBER;
532: l_per_pay_method NUMBER;