DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on PER_ADDRESSES

Line 1007: per_addresses pad

1003: FROM dual
1004: WHERE EXISTS (
1005: SELECT '1'
1006: FROM per_assignments_f paf,
1007: per_addresses pad
1008: WHERE paf.assignment_id = l_ass_id
1009: AND paf.person_id = pad.person_id
1010: AND pad.date_from <= l_effective_date
1011: AND NVL(pad.date_to ,l_effective_date) >= trunc(l_effective_date,'Q')