APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on HR_ORGANIZATION_UNITS

Line 610: , hr_organization_units hou

606: FROM per_all_assignments_f paf
607: , per_all_people_f ppf
608: , per_periods_of_service pps
609: , per_jobs pj
610: , hr_organization_units hou
611: , pay_payrolls_f prl
612: WHERE paf.person_id = ppf.person_id
613: and paf.assignment_id = p_assignment_id
614: AND paf.job_id = pj.job_id(+)

Line 719: l_employer hr_organization_units.name%TYPE;

715: l_assignment_id NUMBER;
716: l_effective_date DATE;
717: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
718: l_job per_jobs.name%TYPE;
719: l_employer hr_organization_units.name%TYPE;
720: l_payroll_id NUMBER;
721: l_asg_num per_all_assignments_f.assignment_number%TYPE;
722: l_det_org_pay_method NUMBER;
723: l_per_pay_method NUMBER;