APPS.PER_NL_FDR_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 242: from hr_organization_units hou

238:
239: BEGIN
240:
241: select 1 INTO l_return_val
242: from hr_organization_units hou
243: where hou.organization_id = p_org_id
244: and EXISTS (SELECT 1 FROM hr_organization_information hoi1
245:
246: WHERE hoi1.org_information_context= 'NL_ORG_INFORMATION'

Line 498: from hr_organization_units hou

494: --hr_utility.set_location('hierarchy not chosen',1);
495: BEGIN
496:
497: select 1 INTO l_return_val
498: from hr_organization_units hou
499: WHERE HOU.BUSINESS_GROUP_ID = p_bg_id
500: AND HOU.organization_id = p_org_id
501: AND EXISTS (SELECT 1 FROM HR_ALL_ORGANIZATION_UNITS HOU1, HR_ORGANIZATION_INFORMATION HOI1
502: WHERE HOU1.BUSINESS_GROUP_ID = p_bg_id

Line 538: FROM hr_organization_units hou

534:
535: BEGIN
536:
537: SELECT 1 INTO l_return_val
538: FROM hr_organization_units hou
539: WHERE hou.organization_id = p_org_id
540: AND hou.business_group_id = p_bg_id
541: AND EXISTS (SELECT 1 FROM hr_organization_units hou1, hr_organization_information hoi1
542:

Line 541: AND EXISTS (SELECT 1 FROM hr_organization_units hou1, hr_organization_information hoi1

537: SELECT 1 INTO l_return_val
538: FROM hr_organization_units hou
539: WHERE hou.organization_id = p_org_id
540: AND hou.business_group_id = p_bg_id
541: AND EXISTS (SELECT 1 FROM hr_organization_units hou1, hr_organization_information hoi1
542:
543: WHERE hoi1.org_information_context= 'NL_ORG_INFORMATION'
544: AND hou1.business_group_id=p_bg_id
545: AND hou1.organization_id=hou.organization_id

Line 567: SELECT 1 FROM hr_organization_units hou2, hr_organization_information hoi2

563: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))
564:
565: UNION
566:
567: SELECT 1 FROM hr_organization_units hou2, hr_organization_information hoi2
568:
569: WHERE hoi2.org_information_context= 'NL_LE_TAX_DETAILS'
570: AND hou2.business_group_id=p_bg_id
571: AND hou2.organization_id=hou.organization_id

Line 933: hr_organization_units hou,

929:
930: from pay_assignment_actions paa,
931: per_all_assignments_f pas,
932: per_assignment_status_types past,
933: hr_organization_units hou,
934: hr_organization_information hoi,
935: per_org_structure_versions posv
936:
937: where posv.organization_structure_id=p_org_struct_id

Line 958: hr_organization_units hou,

954:
955: from pay_assignment_actions paa,
956: per_all_assignments_f pas,
957: per_assignment_status_types past,
958: hr_organization_units hou,
959: hr_organization_information hoi
960:
961: where paa.assignment_action_id = p_assignment_action_id
962: and pas.assignment_id = paa.assignment_id