365: cp_gre_id number) is
366: select 1 from dual
367: where exists
368: (select 'X'
369: from hr_organization_information mag,
370: hr_organization_information gre,
371: hr_all_organization_units hou,
372: pay_payroll_actions ppa
373: where hou.business_group_id = cp_business_group_id
366: select 1 from dual
367: where exists
368: (select 'X'
369: from hr_organization_information mag,
370: hr_organization_information gre,
371: hr_all_organization_units hou,
372: pay_payroll_actions ppa
373: where hou.business_group_id = cp_business_group_id
374: and hou.organization_id = gre.organization_id
388: cp_gre_id number) is
389: select 1 from dual
390: where exists
391: (select 'X'
392: from hr_organization_information mag,
393: hr_organization_information gre,
394: hr_all_organization_units hou,
395: pay_payroll_actions ppa
396: where hou.business_group_id = cp_business_group_id
389: select 1 from dual
390: where exists
391: (select 'X'
392: from hr_organization_information mag,
393: hr_organization_information gre,
394: hr_all_organization_units hou,
395: pay_payroll_actions ppa
396: where hou.business_group_id = cp_business_group_id
397: and hou.organization_id = gre.organization_id
411: cp_pre_id number) is
412: select 1 from dual
413: where exists
414: (select 'X'
415: from hr_organization_information pre,
416: hr_all_organization_units hou,
417: pay_payroll_actions ppa
418: where hou.business_group_id = cp_business_group_id
419: and hou.organization_id = pre.organization_id
433: cp_pre_id number) is
434: select 1 from dual
435: where exists
436: (select 'X'
437: from hr_organization_information pre,
438: hr_all_organization_units hou,
439: pay_payroll_actions ppa
440: where hou.business_group_id = cp_business_group_id
441: and hou.organization_id = pre.organization_id
804: and paf.business_group_id+0 = p_bus_grp;
805:
806: cursor c_all_gres is
807: select hoi.organization_id
808: from hr_organization_information hoi,
809: hr_all_organization_units hou
810: where hoi.org_information_context = 'Canada Employer Identification'
811: and hoi.org_information2 = to_char(p_pre_id)
812: and hou.business_group_id = p_bus_grp
1205: and paf.primary_flag = 'Y';
1206:
1207: cursor c_all_gres is
1208: select hoi.organization_id
1209: from hr_organization_information hoi,
1210: hr_all_organization_units hou
1211: where hoi.org_information_context = 'Canada Employer Identification'
1212: and hoi.org_information2 = to_char(p_pre_id)
1213: and hou.business_group_id = p_bus_grp
1393: and add_months(cp_effective_date, 12) - 1
1394: and paf.assignment_type = 'E'
1395: and paf.primary_flag <> 'Y'
1396: and paa.tax_unit_id in (select hoi.organization_id
1397: from hr_organization_information hoi,
1398: hr_all_organization_units hou
1399: where hoi.org_information_context = 'Canada Employer Identification'
1400: and hoi.org_information2 = to_char(cp_pre_id)
1401: and hou.business_group_id = p_bus_grp
1565: from hr_assignment_set_amendments has,
1566: per_all_assignments_f paf,
1567: pay_assignment_actions paa,
1568: pay_payroll_actions ppa,
1569: hr_organization_information hoi
1570: where has.assignment_set_id = cp_assignment_set_id
1571: and paf.assignment_id = has.assignment_id
1572: and nvl(has.include_or_exclude,'I') = 'I'
1573: and paf.effective_start_date <= add_months(cp_effective_date, 12) - 1
1582: and add_months(cp_effective_date, 12) - 1
1583: and paa.tax_unit_id = hoi.organization_id
1584: and hoi.org_information_context = 'Canada Employer Identification'
1585: and paa.tax_unit_id not in (select hoi1.organization_id
1586: from hr_organization_information hoi1,
1587: hr_all_organization_units hou1
1588: where hoi1.org_information_context = 'Canada Employer Identification'
1589: and hoi1.org_information2 = to_char(cp_pre_id)
1590: and hou1.business_group_id = p_bus_grp