APPS.PAY_IN_PF_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1050: FROM hr_organization_units hou

1046: ,p_branch_code VARCHAR2 )
1047: IS
1048: SELECT hoi.org_information3 branch_name
1049: ,hoi.org_information4 branch_add
1050: FROM hr_organization_units hou
1051: ,hr_organization_information hoi
1052: WHERE hoi.organization_id = hou.organization_id
1053: AND hoi.org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
1054: AND hou.business_group_id = g_bg_id

Line 1459: ,hr_organization_units hou

1455: AND NOT EXISTS ( SELECT paa.assignment_id
1456: FROM pay_assignment_actions paa
1457: ,pay_action_information pai
1458: ,hr_organization_information hoi
1459: ,hr_organization_units hou
1460: ,pay_payroll_actions ppa
1461: WHERE paa.assignment_id = paa_init.assignment_id
1462: AND paa.assignment_action_id = pai.action_context_id
1463: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1545: hr_organization_units hou

1541: (SELECT action_context_id
1542: FROM pay_action_information painfo
1543: WHERE painfo.action_information2 IN (SELECT hoi.org_information7
1544: FROM hr_organization_information hoi ,
1545: hr_organization_units hou
1546: WHERE hoi.organization_id = hou.organization_id
1547: AND hoi.org_information_context = 'PER_IN_COMPANY_RECEP_MAP'
1548: AND hoi.org_information3 = p_business_no
1549: AND hoi.org_information1 = g_challan_year

Line 1941: ,hr_organization_units hou

1937: SELECT hr_pf_org.organization_id pf_org,
1938: org_information10 base_bus_no,
1939: org_information10||org_information9 business_number
1940: FROM hr_organization_information hr_pf_org
1941: ,hr_organization_units hou
1942: WHERE hou.organization_id = hr_pf_org.organization_id
1943: AND hou.business_group_id = g_bg_id
1944: AND org_information_context = 'PER_IN_PF_DF'
1945: AND org_information10||org_information9 = NVL(g_business_no,org_information10||org_information9)