APPS.PAY_CA_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 106: from hr_organization_information hoi

102: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;
103:
104: cursor cur_check_gre_type(cp_tax_unit_id in number) is
105: select hoi.org_information5
106: from hr_organization_information hoi
107: where hoi.organization_id = cp_tax_unit_id
108: and hoi.org_information_context = 'Canada Employer Identification';
109:
110: cursor cur_tu_for_old_run(cp_asg_act_id in number) is

Line 218: l_reporting_level hr_organization_information.org_information1%type;

214: PROCEDURE get_multi_tax_unit_pay_flag
215: (p_bus_grp in number,
216: p_mtup_flag in out nocopy varchar2) IS
217:
218: l_reporting_level hr_organization_information.org_information1%type;
219:
220: BEGIN
221: --
222: select org_information1

Line 224: from hr_organization_information

220: BEGIN
221: --
222: select org_information1
223: into l_reporting_level
224: from hr_organization_information
225: where org_information_context = 'Payroll Archiver Level'
226: and organization_id = p_bus_grp;
227: --
228: --

Line 425: from hr_organization_information hoi

421:
422: begin
423: select put.user_table_name
424: into c_ws_tab_name
425: from hr_organization_information hoi
426: ,pay_user_tables put
427: where hoi.organization_id = p_bg_id
428: and hoi.org_information_context ='Work Schedule'
429: and hoi.org_information1 = put.user_table_id ;