DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2791: per_assignment_status_types pas

2787: in ( SELECT date_earned,
2788: assignment_id
2789: FROM hxc_bee_pref_adj_lines,
2790: per_all_assignments_f paf,
2791: per_assignment_status_types pas
2792: WHERE resource_id = person_id
2793: AND batch_source = 'OTM'
2794: AND paf.effective_end_date = hr_general.end_of_time
2795: AND paf.effective_start_date <= date_earned