APPS.PAY_JP_IWHT_REPORT_PKG dependencies on PAY_JP_IWHT_TAX_V

Line 727: ,pay_jp_iwht_tax_v PJIWTV

723: ,PJIWTV.term_payment_date
724: FROM per_assignments_f PAA
725: ,per_people_f PAP
726: ,pay_assignment_actions PAS
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

Line 765: ,pay_jp_iwht_tax_v PJIWTV

761: ,PJIWTV.term_payment_date
762: FROM per_assignments_f PAA
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

Line 1085: FROM pay_jp_iwht_tax_v PJIWTV

1081: , TO_CHAR(PJIWTV.term_payment_date, 'YY', 'NLS_CALENDAR=''Japanese Imperial''') TERM_PAYMENT_DATE_YY
1082: , TO_CHAR(PJIWTV.term_payment_date, 'MM', 'NLS_CALENDAR=''Japanese Imperial''') TERM_PAYMENT_DATE_MM
1083: , TO_CHAR(PJIWTV.term_payment_date, 'DD', 'NLS_CALENDAR=''Japanese Imperial''') TERM_PAYMENT_DATE_DD
1084: , TO_CHAR(PJIWTV.date_earned, 'EYY MM DD', 'NLS_CALENDAR=''Japanese Imperial''') DATE_EARNED
1085: FROM pay_jp_iwht_tax_v PJIWTV
1086: WHERE PJIWTV.assignment_id = p_assignment_id;
1087:
1088: --
1089: lr_iwht_emp cur_iwht_emp%ROWTYPE;

Line 1525: ,pay_jp_iwht_tax_v PJIWTV

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
1527: AND PAF.assignment_id = PAA.assignment_id
1528: AND PPF.person_id = PAF.person_id
1529: AND PAF.organization_id = HAOU.organization_id