APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 944: hr_organization_information hoi_bg, -- Business Group

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

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

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

Line 1897: hr_organization_information HOI

1893: SELECT fnd_date.canonical_to_date(org_information11)
1894: INTO l_beg_of_fiscal_year
1895: FROM pay_payroll_actions PACT,
1896: pay_assignment_actions ASSACT,
1897: hr_organization_information HOI
1898: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1899: AND HOI.organization_id = PACT.business_group_id
1900: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1901: AND ASSACT.assignment_action_id = p_owner_assignment_action_id;

Line 1911: hr_organization_information HOI

1907: SELECT fnd_date.canonical_to_date(org_information11)
1908: INTO l_beg_of_fiscal_year
1909: FROM pay_payroll_actions PACT,
1910: pay_assignment_actions ASSACT,
1911: hr_organization_information HOI
1912: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
1913: AND HOI.organization_id = PACT.business_group_id
1914: AND PACT.payroll_action_id = ASSACT.payroll_action_id
1915: AND ASSACT.assignment_action_id = p_owner_assignment_action_id;