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 1929: hr_organization_information HOI

1925: SELECT fnd_date.canonical_to_date(org_information11)
1926: INTO l_beg_of_fiscal_year
1927: FROM pay_payroll_actions PACT,
1928: pay_assignment_actions ASSACT,
1929: hr_organization_information HOI
1930: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1931: AND HOI.organization_id = PACT.business_group_id
1932: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1933: AND ASSACT.assignment_action_id = p_owner_assignment_action_id;

Line 1943: hr_organization_information HOI

1939: SELECT fnd_date.canonical_to_date(org_information11)
1940: INTO l_beg_of_fiscal_year
1941: FROM pay_payroll_actions PACT,
1942: pay_assignment_actions ASSACT,
1943: hr_organization_information HOI
1944: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1945: AND HOI.organization_id = PACT.business_group_id
1946: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1947: AND ASSACT.assignment_action_id = p_owner_assignment_action_id;