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 3240: hr_all_organization_units hou,

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

Line 3778: hr_all_organization_units hou,

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

Line 4385: hr_all_organization_units hou

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

Line 4406: hr_all_organization_units hou

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