APPS.PAY_JP_IWHT_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 715: CURSOR lcu_assact_r( p_business_group_id per_assignments_f.business_group_id%TYPE

711: -- CALLED BY
712: -- None
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

Line 724: FROM per_assignments_f PAA

720: )
721: IS
722: SELECT DISTINCT PJIWTV.assignment_id
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

Line 753: CURSOR lcu_assact( p_business_group_id per_assignments_f.business_group_id%TYPE

749: AND NVL(p_termination_date_to,PPOF.actual_termination_date)
750: OR --PPOF.actual_termination_date IS NULL -- commented for the bug #9527198
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

Line 762: FROM per_assignments_f PAA

758: )
759: IS
760: SELECT DISTINCT PJIWTV.assignment_id
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

Line 1518: FROM per_assignments_f PAF

1514: END IF;
1515: -- Added above for the Bug # 9569078
1516:
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