APPS.HRASSACT dependencies on HR_ORGANIZATION_INFORMATION

Line 5395: l_tax_group hr_organization_information.org_information5%type;

5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;
5393: l_st2_needed pay_legislation_rules.rule_mode%type;
5394: l_value pay_action_parameters.parameter_value%type;
5395: l_tax_group hr_organization_information.org_information5%type;
5396: begin
5397: g_debug := hr_utility.debug_enabled;
5398: --
5399: -- To process the reversal, we need to

Line 6425: from hr_organization_information hoi

6421: l_org_id number;
6422: begin
6423: select organization_id
6424: into l_org_id
6425: from hr_organization_information hoi
6426: where hoi.organization_id = l_ctx_value
6427: and hoi.org_information_context = 'CLASS'
6428: and hoi.org_information1 = 'HR_PAYEE';
6429:

Line 6528: tax_group hr_organization_information.org_information5%type;

6524: if g_debug then
6525: hr_utility.set_location(c_indent,140);
6526: end if;
6527: declare
6528: tax_group hr_organization_information.org_information5%type;
6529: asg_id number;
6530: pay_id number;
6531: begin
6532: --

Line 6541: from hr_organization_information hoi,

6537: select hoi.org_information5,
6538: paa.assignment_id
6539: into tax_group,
6540: asg_id
6541: from hr_organization_information hoi,
6542: pay_assignment_actions paa
6543: where UPPER(hoi.org_information_context) = 'FEDERAL TAX RULES'
6544: and hoi.organization_id = paa.tax_unit_id
6545: and paa.assignment_action_id = p_assact

Line 6555: from hr_organization_information hoi,

6551: select hoi.org_information4,
6552: paa.assignment_id
6553: into tax_group,
6554: asg_id
6555: from hr_organization_information hoi,
6556: pay_assignment_actions paa
6557: where UPPER(hoi.org_information_context) = 'CANADA EMPLOYER IDENTIFICATION'
6558: and hoi.organization_id = paa.tax_unit_id
6559: and paa.assignment_action_id = p_assact