DBA Data[Home] [Help]

APPS.PAY_BALANCE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 11064: l_tax_group hr_organization_information.org_information5%type;

11060: l_org_id_iv varchar2(30);
11061: l_iv_found boolean;
11062: l_num_found boolean;
11063: l_value pay_action_parameters.parameter_value%type;
11064: l_tax_group hr_organization_information.org_information5%type;
11065: l_bus_grp per_business_groups_perf.business_group_id%type;
11066: leg_code per_business_groups_perf.legislation_code%type;
11067: l_found boolean;
11068: cxt_id number;

Line 11258: from hr_organization_information hoi,

11254:
11255: if leg_code = 'US' then
11256: select hoi.org_information5
11257: into l_tax_group
11258: from hr_organization_information hoi,
11259: pay_assignment_actions paa
11260: where UPPER(hoi.org_information_context) = 'FEDERAL TAX RULES'
11261: and hoi.organization_id = paa.tax_unit_id
11262: and paa.assignment_action_id = p_asg_action

Line 11267: from hr_organization_information hoi,

11263: and hoi.org_information5 is not null;
11264: else
11265: select hoi.org_information4
11266: into l_tax_group
11267: from hr_organization_information hoi,
11268: pay_assignment_actions paa
11269: where UPPER(hoi.org_information_context) = 'CANADA EMPLOYER IDENTIFICATION'
11270: and hoi.organization_id = paa.tax_unit_id
11271: and paa.assignment_action_id = p_asg_action