DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2051: per_assignment_status_types pas

2047: in ( SELECT date_earned,
2048: assignment_id
2049: FROM hxc_bee_pref_adj_lines,
2050: per_all_assignments_f paf,
2051: per_assignment_status_types pas
2052: WHERE resource_id = person_id
2053: AND batch_source = 'OTM'
2054: AND paf.effective_end_date = hr_general.end_of_time
2055: AND paf.effective_start_date <= date_earned