DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ADHOC dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 34: ,hr_assignment_set_amendments hasa

30: SELECT DISTINCT
31: paf.assignment_id
32: FROM per_all_assignments_f paf
33: ,per_business_groups pbf
34: ,hr_assignment_set_amendments hasa
35: WHERE pbf.legislation_code = 'GB'
36: AND pbf.business_group_id = paf.business_group_id
37: AND (
38: p_effective_date_c BETWEEN paf.effective_start_date