DBA Data[Home] [Help]

APPS.PAY_US_MWR_REPORTING_PKG dependencies on PER_ASSIGNMENTS_F

Line 1006: FROM per_assignments_f paf,

1002: INTO l_ma_resides_true
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