DBA Data[Home] [Help]

APPS.PAY_NL_IZA_UPLOAD dependencies on HR_NL_ORG_INFO

Line 1453: and hr_nl_org_info.Get_iza_Org_Id(p_org_struct_version_id,paa.organization_id) = v_org_id

1449: from per_all_assignments_f paa
1450: where paa.person_id = v_person_id
1451: and paa.primary_flag = 'Y'
1452: and paa.business_group_id = v_bg_id
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