APPS.PAY_CA_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 138: from hr_organization_information hoi

134: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;
135:
136: cursor cur_check_gre_type(cp_tax_unit_id in number) is
137: select hoi.org_information5
138: from hr_organization_information hoi
139: where hoi.organization_id = cp_tax_unit_id
140: and hoi.org_information_context = 'Canada Employer Identification';
141:
142: cursor cur_tu_for_old_run(cp_asg_act_id in number) is

Line 250: l_reporting_level hr_organization_information.org_information1%type;

246: PROCEDURE get_multi_tax_unit_pay_flag
247: (p_bus_grp in number,
248: p_mtup_flag in out nocopy varchar2) IS
249:
250: l_reporting_level hr_organization_information.org_information1%type;
251:
252: BEGIN
253: --
254: select org_information1

Line 256: from hr_organization_information

252: BEGIN
253: --
254: select org_information1
255: into l_reporting_level
256: from hr_organization_information
257: where org_information_context = 'Payroll Archiver Level'
258: and organization_id = p_bus_grp;
259: --
260: --

Line 1112: from hr_organization_information hoi

1108:
1109: begin
1110: select put.user_table_name
1111: into c_ws_tab_name
1112: from hr_organization_information hoi
1113: ,pay_user_tables put
1114: where hoi.organization_id = p_bg_id
1115: and hoi.org_information_context ='Work Schedule'
1116: and hoi.org_information1 = put.user_table_id ;