APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 137: l_tax_group hr_organization_information.org_information5%type;

133: t_gre_id number(15);
134: t_payroll_action_id pay_payroll_actions.payroll_action_id%type; --:PACTID
135: l_row_count number :=0;
136: l_tax_type varchar2(240);
137: l_tax_group hr_organization_information.org_information5%type;
138: l_date_prm varchar2(20);
139: l_as_of_date date;
140:
141: -- bug # 2938556

Line 142: l_prev_tg hr_organization_information.org_information5%type;

138: l_date_prm varchar2(20);
139: l_as_of_date date;
140:
141: -- bug # 2938556
142: l_prev_tg hr_organization_information.org_information5%type;
143: l_tg_changed varchar2(1):= 'Y';
144: g_get_param varchar2(1):= 'Y';
145: g_inserted_asg_action_id_flag varchar2(1):= 'N';
146: g_inserted_asg_action_id number;

Line 170: from hr_organization_information

166: function tax_group(p_tax_unit_id number) return VARCHAR2
167: is
168: cursor c_tax_group(cp_tax_unit_id in number) is
169: select org_information5
170: from hr_organization_information
171: where organization_id = cp_tax_unit_id
172: and org_information_context = 'Federal Tax Rules';
173:
174: lv_tax_group varchar2(240);

Line 207: -- lv_tax_group hr_organization_information.org_information5%TYPE ;

203: )
204: RETURN NUMBER IS
205: ln_balance_value number := 0;
206: ln_catchup_balance_value number := 0;
207: -- lv_tax_group hr_organization_information.org_information5%TYPE ;
208: lv_tg_balance_name varchar2(1000);
209: ln_defined_bal_id ff_user_entities.creator_id%TYPE;
210: lv_bal_flag varchar2(30) := ' ';
211: --