DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PER_ASSIGNMENTS_F

Line 1543: FROM per_assignments_f paf

1539: AND paa.tax_unit_id = hou.organization_id
1540: AND paa.pre_payment_id = ppp.pre_payment_id
1541: AND EXISTS
1542: ( SELECT 1
1543: FROM per_assignments_f paf
1544: WHERE paf.assignment_id = paa.assignment_id
1545: AND ppa.effective_date BETWEEN paf.effective_start_date and paf.effective_end_date
1546: )
1547: ORDER BY ppp.org_payment_method_id, hou.organization_id;