APPS.PAY_NL_IZA_UPLOAD dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 146: FROM per_assignment_status_types past, per_all_assignments_f asg

142: and v_period_end_date between pap.effective_start_date and pap.effective_end_date
143: and paa.effective_start_date =
144: (
145: SELECT MIN(asg.effective_start_date)
146: FROM per_assignment_status_types past, per_all_assignments_f asg
147: WHERE asg.assignment_id = paa.assignment_id
148: and past.per_system_status = 'ACTIVE_ASSIGN'
149: and asg.assignment_status_type_id = past.assignment_status_type_id
150: and asg.effective_start_date <= v_period_End_Date

Line 174: FROM per_assignment_status_types past, per_all_assignments_f asg

170: and v_period_end_date between pap.effective_start_date and pap.effective_end_date
171: and paa.effective_start_date =
172: (
173: SELECT MIN(asg.effective_start_date)
174: FROM per_assignment_status_types past, per_all_assignments_f asg
175: WHERE asg.assignment_id = paa.assignment_id
176: and past.per_system_status = 'ACTIVE_ASSIGN'
177: and asg.assignment_status_type_id = past.assignment_status_type_id
178: and asg.effective_start_date <= v_period_End_Date

Line 1457: FROM per_assignment_status_types past, per_all_assignments_f asg

1453: and hr_nl_org_info.Get_iza_Org_Id(p_org_struct_version_id,paa.organization_id) = v_org_id
1454: and paa.effective_start_date =
1455: (
1456: SELECT MIN(asg.effective_start_date)
1457: FROM per_assignment_status_types past, per_all_assignments_f asg
1458: WHERE asg.assignment_id = paa.assignment_id
1459: and past.per_system_status = 'ACTIVE_ASSIGN'
1460: and asg.assignment_status_type_id = past.assignment_status_type_id
1461: and asg.effective_start_date <= v_period_end_date