APPS.PAY_BALANCE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 10343: l_tax_group hr_organization_information.org_information5%type;

10339: l_org_id_iv varchar2(30);
10340: l_iv_found boolean;
10341: l_num_found boolean;
10342: l_value pay_action_parameters.parameter_value%type;
10343: l_tax_group hr_organization_information.org_information5%type;
10344: l_bus_grp per_business_groups_perf.business_group_id%type;
10345: leg_code per_business_groups_perf.legislation_code%type;
10346: l_found boolean;
10347: cxt_id number;

Line 10535: from hr_organization_information hoi,

10531:
10532: if leg_code = 'US' then
10533: select hoi.org_information5
10534: into l_tax_group
10535: from hr_organization_information hoi,
10536: pay_assignment_actions paa
10537: where UPPER(hoi.org_information_context) = 'FEDERAL TAX RULES'
10538: and hoi.organization_id = paa.tax_unit_id
10539: and paa.assignment_action_id = p_asg_action

Line 10544: from hr_organization_information hoi,

10540: and hoi.org_information5 is not null;
10541: else
10542: select hoi.org_information4
10543: into l_tax_group
10544: from hr_organization_information hoi,
10545: pay_assignment_actions paa
10546: where UPPER(hoi.org_information_context) = 'CANADA EMPLOYER IDENTIFICATION'
10547: and hoi.organization_id = paa.tax_unit_id
10548: and paa.assignment_action_id = p_asg_action