APPS.PAY_IN_PF_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 1054: FROM hr_organization_units hou

1050: ,p_branch_code VARCHAR2 )
1051: IS
1052: SELECT hoi.org_information3 branch_name
1053: ,hoi.org_information4 branch_add
1054: FROM hr_organization_units hou
1055: ,hr_organization_information hoi
1056: WHERE hoi.organization_id = hou.organization_id
1057: AND hoi.org_information_context = 'PER_IN_PF_BANK_BRANCH_DTLS'
1058: AND hou.business_group_id = g_bg_id

Line 1463: ,hr_organization_units hou

1459: AND NOT EXISTS ( SELECT paa.assignment_id
1460: FROM pay_assignment_actions paa
1461: ,pay_action_information pai
1462: ,hr_organization_information hoi
1463: ,hr_organization_units hou
1464: ,pay_payroll_actions ppa
1465: WHERE paa.assignment_id = paa_init.assignment_id
1466: AND paa.assignment_action_id = pai.action_context_id
1467: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1549: hr_organization_units hou

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

Line 1945: ,hr_organization_units hou

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