DBA Data[Home] [Help]

APPS.PAY_NEGBAL_PKG dependencies on PER_ADDRESSES

Line 74: per_addresses pad

70: FROM dual
71: WHERE EXISTS (
72: SELECT '1'
73: FROM per_assignments_f paf,
74: per_addresses pad
75: WHERE paf.assignment_id = p_assignment_id AND
76: paf.person_id = pad.person_id AND
77: pad.date_from <= p_period_end AND
78: NVL(pad.date_to ,p_period_end) >= p_period_start AND