APPS.PER_JP_WRKREG_REPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 441: ,hr_all_organization_units_tl HAOUT

437: sqlstr := ' SELECT PAA.rowid
438: FROM per_assignments_f PAF
439: ,pay_assignment_actions PAA
440: ,per_people_f PPF
441: ,hr_all_organization_units_tl HAOUT
442: ,hr_all_organization_units HAOU
443: ,per_periods_of_service PPS
444: WHERE PAA.payroll_action_id = :pactid
445: AND PAF.assignment_id = PAA.assignment_id

Line 442: ,hr_all_organization_units HAOU

438: FROM per_assignments_f PAF
439: ,pay_assignment_actions PAA
440: ,per_people_f PPF
441: ,hr_all_organization_units_tl HAOUT
442: ,hr_all_organization_units HAOU
443: ,per_periods_of_service PPS
444: WHERE PAA.payroll_action_id = :pactid
445: AND PAF.assignment_id = PAA.assignment_id
446: AND PPF.person_id = PAF.person_id

Line 610: ,hr_all_organization_units HAOU

606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF
608: ,pay_population_ranges PPR
609: ,pay_payroll_actions PPA
610: ,hr_all_organization_units HAOU
611: WHERE PAA.person_id = PAP.person_id
612: AND PPA.payroll_action_id = PPR.payroll_action_id
613: AND PPA.payroll_action_id = p_payroll_action_id
614: AND PPR.chunk_number = p_chunk

Line 664: ,hr_all_organization_units HAOU

660: ,per_people_f PAP
661: ,pay_assignment_actions PAS
662: ,per_jp_wrkreg_emp_v PJWREV
663: ,per_periods_of_service PPOF
664: ,hr_all_organization_units HAOU
665: WHERE PAA.person_id = PAP.person_id
666: AND PAA.person_id BETWEEN p_start_person_id
667: AND p_end_person_id
668: AND PAS.assignment_id = PAA.assignment_id