APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 349: FROM hr_organization_information_v org

345: SELECT org.org_information1,
346: org.org_information2,
347: org.org_information3,
348: org.org_information4
349: FROM hr_organization_information_v org
350: WHERE org.org_information_context = p_context
351: AND org.organization_id = p_bg_id;
352: --
353: --

Line 591: ,hr_organization_information hoi

587: ,hou1.name tax_office_name
588: ,hoi_tax.org_information4 reg_no
589: FROM hr_all_organization_units hou
590: ,hr_all_organization_units hou1
591: ,hr_organization_information hoi
592: ,hr_organization_information hoi_tax
593: WHERE hoi.org_information_context = 'CLASS'
594: AND hoi.org_information1 = 'HR_ORG'
595: AND hoi.organization_id = HOU.organization_id

Line 592: ,hr_organization_information hoi_tax

588: ,hoi_tax.org_information4 reg_no
589: FROM hr_all_organization_units hou
590: ,hr_all_organization_units hou1
591: ,hr_organization_information hoi
592: ,hr_organization_information hoi_tax
593: WHERE hoi.org_information_context = 'CLASS'
594: AND hoi.org_information1 = 'HR_ORG'
595: AND hoi.organization_id = HOU.organization_id
596: AND hou.business_group_id = p_bus_group_id