DBA Data[Home] [Help]

APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1201: FROM per_all_assignments_f paf,

1197:
1198:
1199: CURSOR c_get_wah_flag(l_assignment_action_id number, l_effective_date date) IS
1200: SELECT paf.work_at_home
1201: FROM per_all_assignments_f paf,
1202: pay_assignment_actions paa
1203: WHERE paa.assignment_action_id= l_assignment_action_id
1204: AND paa.assignment_id = paf.assignment_id
1205: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;