APPS.PAY_JP_IWHT_REPORT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 717: , p_withholding_agent hr_all_organization_units_vl.organization_id%TYPE

713: --************************************************************************
714: AS
715: CURSOR lcu_assact_r( p_business_group_id per_assignments_f.business_group_id%TYPE
716: , p_subject_year NUMBER
717: , p_withholding_agent hr_all_organization_units_vl.organization_id%TYPE
718: , p_termination_date_from DATE
719: , p_termination_date_to DATE
720: )
721: IS

Line 731: ,hr_all_organization_units HAOU

727: ,pay_jp_iwht_tax_v PJIWTV
728: ,per_periods_of_service PPOF
729: ,pay_population_ranges PPR
730: ,pay_payroll_actions PPA
731: ,hr_all_organization_units HAOU
732: WHERE PAA.person_id = PAP.person_id
733: AND PPA.payroll_action_id = PPR.payroll_action_id
734: AND PPR.person_id = PAP.person_id
735: AND PAS.assignment_id = PAA.assignment_id

Line 755: , p_withholding_agent hr_all_organization_units_vl.organization_id%TYPE

751: (p_termination_date_from IS NULL AND p_termination_date_to IS NULL));
752: --
753: CURSOR lcu_assact( p_business_group_id per_assignments_f.business_group_id%TYPE
754: , p_subject_year NUMBER
755: , p_withholding_agent hr_all_organization_units_vl.organization_id%TYPE
756: , p_termination_date_from DATE
757: , p_termination_date_to DATE
758: )
759: IS

Line 767: ,hr_all_organization_units HAOU

763: ,per_people_f PAP
764: ,pay_assignment_actions PAS
765: ,pay_jp_iwht_tax_v PJIWTV
766: ,per_periods_of_service PPOF
767: ,hr_all_organization_units HAOU
768: WHERE PAA.person_id = PAP.person_id
769: AND PAA.person_id BETWEEN p_start_person_id
770: AND p_end_person_id
771: AND PAS.assignment_id = PAA.assignment_id

Line 1521: ,hr_all_organization_units_tl HAOUT

1517: sqlstr := ' SELECT PAA.rowid
1518: FROM per_assignments_f PAF
1519: ,pay_assignment_actions PAA
1520: ,per_people_f PPF
1521: ,hr_all_organization_units_tl HAOUT
1522: ,hr_all_organization_units HAOU
1523: ,per_periods_of_service PPS
1524: ,pay_jp_iwht_emp_v PJIWEV
1525: ,pay_jp_iwht_tax_v PJIWTV

Line 1522: ,hr_all_organization_units HAOU

1518: FROM per_assignments_f PAF
1519: ,pay_assignment_actions PAA
1520: ,per_people_f PPF
1521: ,hr_all_organization_units_tl HAOUT
1522: ,hr_all_organization_units HAOU
1523: ,per_periods_of_service PPS
1524: ,pay_jp_iwht_emp_v PJIWEV
1525: ,pay_jp_iwht_tax_v PJIWTV
1526: WHERE PAA.payroll_action_id = :pactid