DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ADDRESSES

Line 547: per_addresses pad

543: FROM dual
544: WHERE EXISTS (
545: SELECT '1'
546: FROM per_assignments_f paf,
547: per_addresses pad
548: WHERE paf.assignment_id = p_assignment_id AND
549: paf.person_id = pad.person_id AND
550: pad.date_from <= p_period_end AND
551: NVL(pad.date_to ,p_period_end) >= p_period_start AND