[Home] [Help]
3235: ppa.payroll_id,
3236: ppa.effective_date,
3237: ppa.report_type,
3238: hoi.org_information2
3239: from hr_organization_information hoi,
3240: hr_all_organization_units hou,
3241: pay_payroll_actions ppa
3242: where hou.business_group_id = fp_b_g_id
3243: and hoi.organization_id = hou.organization_id
3261:
3262: cursor cur_rl_trans_y_n ( cp_org_id in number,
3263: cp_qin in varchar2 ) is
3264: select 'Y'
3265: from hr_organization_information
3266: where organization_id = cp_org_id
3267: and org_information2 = cp_qin
3268: and org_information3 = 'Y'
3269: and org_information_context = 'Prov Reporting Est';
3773: hou.name,
3774: ppa.payroll_id,
3775: ppa.effective_date,
3776: ppa.report_type
3777: from hr_organization_information hoi,
3778: hr_all_organization_units hou,
3779: pay_payroll_actions ppa
3780: where hou.business_group_id = fp_b_g_id
3781: and hoi.organization_id = hou.organization_id
3796: the type of transmitter or not */
3797:
3798: cursor cur_trans_y_n ( cp_org_id in number ) is
3799: select 'Y'
3800: from hr_organization_information
3801: where organization_id = cp_org_id
3802: and org_information1 = 'Y'
3803: and org_information_context = 'Fed Magnetic Reporting';
3804:
4380: begin
4381: /* Used to print GRE name as report parameter. */
4382: select name, org_information1
4383: into sv_gre_name, sv_busi_no
4384: from hr_organization_information hoi,
4385: hr_all_organization_units hou
4386: where hoi.organization_id = hou.organization_id
4387: and hoi.organization_id = p_gre
4388: and hoi.org_information_context = 'Canada Employer Identification'
4401: select hou.name,
4402: hoi.org_information2
4403: into sv_pre_name,
4404: sv_qin
4405: from hr_organization_information hoi,
4406: hr_all_organization_units hou
4407: where hoi.organization_id = hou.organization_id
4408: and hoi.organization_id = p_pre
4409: and hoi.org_information1 = 'QC'