APPS.PAY_CA_YEER_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 90: 15-JUN-2005 ssouresr 115.32 Replaced hr_organization_units with hr_all_organization_units

86: 28-NOV-2004 ssouresr 115.30 Changed 'Quebec Bn' to 'Quebec Identification Number'
87: 29-APR-2005 ssouresr 115.31 The Year End Exception Report now picks up T4A
88: Amendment data too. Also made changes so that box
89: names with negative balances are correctly displayed
90: 15-JUN-2005 ssouresr 115.32 Replaced hr_organization_units with hr_all_organization_units
91: this allows correct output to be produced when a
92: a secure user runs the report
93: 30-AUG-2005 ssattini 115.33 2689672 Modified prov_employer_validation,provincial_process
94: prov_employee_validation and print_employee to print YEER

Line 2874: hr_all_organization_units hou,

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
2878: and hoi.org_information_context = 'Prov Reporting Est'

Line 3318: hr_all_organization_units hou,

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
3322: and hoi.org_information_context = 'Canada Employer Identification'

Line 3823: hr_all_organization_units hou

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'
3827: and hou.business_group_id = p_b_g_id;

Line 3844: hr_all_organization_units hou

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'
3848: and hoi.org_information_context = 'Prov Reporting Est'