APPS.PAY_US_BALANCE_VIEW_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 940: hr_organization_information hoi_bg, -- Business Group

936: 'US', hoi_gre.org_information5,
937: 'CA', hoi_gre.org_information4)
938: into l_tax_group
939: from
940: hr_organization_information hoi_bg, -- Business Group
941: hr_organization_information hoi_gre, -- US or CA Context
942: hr_all_organization_units hou -- GRE
943: where hou.organization_id = to_number(p_context_value)
944: and hoi_gre.organization_id = hou.organization_id

Line 941: hr_organization_information hoi_gre, -- US or CA Context

937: 'CA', hoi_gre.org_information4)
938: into l_tax_group
939: from
940: hr_organization_information hoi_bg, -- Business Group
941: hr_organization_information hoi_gre, -- US or CA Context
942: hr_all_organization_units hou -- GRE
943: where hou.organization_id = to_number(p_context_value)
944: and hoi_gre.organization_id = hou.organization_id
945: and hoi_bg.organization_id = hou.business_group_id

Line 1905: hr_organization_information HOI

1901: SELECT fnd_date.canonical_to_date(org_information11)
1902: INTO l_beg_of_fiscal_year
1903: FROM pay_payroll_actions PACT,
1904: pay_assignment_actions ASSACT,
1905: hr_organization_information HOI
1906: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1907: AND HOI.organization_id = PACT.business_group_id
1908: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1909: AND ASSACT.assignment_action_id = p_owner_assignment_action_id;

Line 1919: hr_organization_information HOI

1915: SELECT fnd_date.canonical_to_date(org_information11)
1916: INTO l_beg_of_fiscal_year
1917: FROM pay_payroll_actions PACT,
1918: pay_assignment_actions ASSACT,
1919: hr_organization_information HOI
1920: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1921: AND HOI.organization_id = PACT.business_group_id
1922: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1923: AND ASSACT.assignment_action_id = p_owner_assignment_action_id;