[Home] [Help]
2869: ppa.payroll_id,
2870: ppa.effective_date,
2871: ppa.report_type,
2872: hoi.org_information2
2873: from hr_organization_information hoi,
2874: hr_all_organization_units hou,
2875: pay_payroll_actions ppa
2876: where hou.business_group_id = fp_b_g_id
2877: and hoi.organization_id = hou.organization_id
2895:
2896: cursor cur_rl_trans_y_n ( cp_org_id in number,
2897: cp_qin in varchar2 ) is
2898: select 'Y'
2899: from hr_organization_information
2900: where organization_id = cp_org_id
2901: and org_information2 = cp_qin
2902: and org_information3 = 'Y'
2903: and org_information_context = 'Prov Reporting Est';
3313: hou.name,
3314: ppa.payroll_id,
3315: ppa.effective_date,
3316: ppa.report_type
3317: from hr_organization_information hoi,
3318: hr_all_organization_units hou,
3319: pay_payroll_actions ppa
3320: where hou.business_group_id = fp_b_g_id
3321: and hoi.organization_id = hou.organization_id
3336: the type of transmitter or not */
3337:
3338: cursor cur_trans_y_n ( cp_org_id in number ) is
3339: select 'Y'
3340: from hr_organization_information
3341: where organization_id = cp_org_id
3342: and org_information1 = 'Y'
3343: and org_information_context = 'Fed Magnetic Reporting';
3344:
3818: begin
3819: /* Used to print GRE name as report parameter. */
3820: select name, org_information1
3821: into sv_gre_name, sv_busi_no
3822: from hr_organization_information hoi,
3823: hr_all_organization_units hou
3824: where hoi.organization_id = hou.organization_id
3825: and hoi.organization_id = p_gre
3826: and hoi.org_information_context = 'Canada Employer Identification'
3839: select hou.name,
3840: hoi.org_information2
3841: into sv_pre_name,
3842: sv_qin
3843: from hr_organization_information hoi,
3844: hr_all_organization_units hou
3845: where hoi.organization_id = hou.organization_id
3846: and hoi.organization_id = p_pre
3847: and hoi.org_information1 = 'QC'