APPS.HRASSACT dependencies on HR_ORGANIZATION_INFORMATION

Line 5163: l_tax_group hr_organization_information.org_information5%type;

5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;
5161: l_st2_needed pay_legislation_rules.rule_mode%type;
5162: l_value pay_action_parameters.parameter_value%type;
5163: l_tax_group hr_organization_information.org_information5%type;
5164: begin
5165: g_debug := hr_utility.debug_enabled;
5166: --
5167: -- To process the reversal, we need to

Line 6161: from hr_organization_information hoi

6157: l_org_id number;
6158: begin
6159: select organization_id
6160: into l_org_id
6161: from hr_organization_information hoi
6162: where hoi.organization_id = l_ctx_value
6163: and hoi.org_information_context = 'CLASS'
6164: and hoi.org_information1 = 'HR_PAYEE';
6165:

Line 6264: tax_group hr_organization_information.org_information5%type;

6260: if g_debug then
6261: hr_utility.set_location(c_indent,140);
6262: end if;
6263: declare
6264: tax_group hr_organization_information.org_information5%type;
6265: asg_id number;
6266: pay_id number;
6267: begin
6268: --

Line 6277: from hr_organization_information hoi,

6273: select hoi.org_information5,
6274: paa.assignment_id
6275: into tax_group,
6276: asg_id
6277: from hr_organization_information hoi,
6278: pay_assignment_actions paa
6279: where UPPER(hoi.org_information_context) = 'FEDERAL TAX RULES'
6280: and hoi.organization_id = paa.tax_unit_id
6281: and paa.assignment_action_id = p_assact

Line 6291: from hr_organization_information hoi,

6287: select hoi.org_information4,
6288: paa.assignment_id
6289: into tax_group,
6290: asg_id
6291: from hr_organization_information hoi,
6292: pay_assignment_actions paa
6293: where UPPER(hoi.org_information_context) = 'CANADA EMPLOYER IDENTIFICATION'
6294: and hoi.organization_id = paa.tax_unit_id
6295: and paa.assignment_action_id = p_assact