DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ADDRESSES

Line 611: per_addresses pad

607: FROM dual
608: WHERE EXISTS (
609: SELECT '1'
610: FROM per_assignments_f paf,
611: per_addresses pad
612: WHERE paf.assignment_id = p_assignment_id AND
613: paf.person_id = pad.person_id AND
614: pad.date_from <= p_period_end AND
615: NVL(pad.date_to ,p_period_end) >= p_period_start AND