[Home] [Help]
17: ppa.payroll_action_id = paa.payroll_action_id
18: AND hoi.org_information_context = 'Fed Magnetic Reporting'
19: AND hoi.organization_id = paa.tax_unit_id
20: AND hoi.org_information1 = 'Y'
21: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
22: AND ppa.action_status = 'C';
23:
24: /**************************************************************************/
25: CURSOR mag_t4_cancel_employer IS
40: pay_action_interlocks int,
41: hr_organization_information hoi1
42: WHERE paa.payroll_action_id = ppa.payroll_action_id
43: AND hoi1.organization_id = paa1.tax_unit_id
44: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
45: AND int.locking_action_id = paa.assignment_action_id
46: AND paa1.assignment_action_id = int.locked_action_id
47: AND ppa1.payroll_action_id = paa1.payroll_action_id
48: AND hoi1.org_information11 =pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE_ID')
44: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
45: AND int.locking_action_id = paa.assignment_action_id
46: AND paa1.assignment_action_id = int.locked_action_id
47: AND ppa1.payroll_action_id = paa1.payroll_action_id
48: AND hoi1.org_information11 =pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE_ID')
49: AND hoi1.org_information5 like '%T4%'
50: AND hoi1.org_information_context = 'Canada Employer Identification'
51: AND ppa1.report_type in ('T4','CAEOY_T4_AMEND_PP')
52: AND to_char(ppa.effective_date
49: AND hoi1.org_information5 like '%T4%'
50: AND hoi1.org_information_context = 'Canada Employer Identification'
51: AND ppa1.report_type in ('T4','CAEOY_T4_AMEND_PP')
52: AND to_char(ppa.effective_date
53: ,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
54: AND to_char(ppa.effective_date
55: ,'DD-MM') = '31-12'
56: AND fdi.user_name = 'CAEOY_EMPLOYER_NAME'
57: AND ppa1.payroll_action_id = fai.context1
74: pay_action_interlocks pai,
75: pay_assignment_actions paa,
76: pay_payroll_actions ppa,
77: pay_assignment_actions paa_mag
78: WHERE ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
79: AND paa.payroll_action_id = ppa.payroll_action_id
80: AND pai.locking_action_id = paa.assignment_action_id
81: AND paf.assignment_id = paa.assignment_id
82: AND ppf.person_id = paf.person_id
79: AND paa.payroll_action_id = ppa.payroll_action_id
80: AND pai.locking_action_id = paa.assignment_action_id
81: AND paf.assignment_id = paa.assignment_id
82: AND ppf.person_id = paf.person_id
83: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
84: BETWEEN paf.effective_start_date and paf.effective_end_date
85: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
86: BETWEEN ppf.effective_start_date and ppf.effective_end_date
87: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
81: AND paf.assignment_id = paa.assignment_id
82: AND ppf.person_id = paf.person_id
83: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
84: BETWEEN paf.effective_start_date and paf.effective_end_date
85: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
86: BETWEEN ppf.effective_start_date and ppf.effective_end_date
87: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
88: AND paa_mag.assignment_action_id = pai.locked_action_id
89: AND paa.action_status = 'C'
83: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
84: BETWEEN paf.effective_start_date and paf.effective_end_date
85: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
86: BETWEEN ppf.effective_start_date and ppf.effective_end_date
87: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
88: AND paa_mag.assignment_action_id = pai.locked_action_id
89: AND paa.action_status = 'C'
90: AND paa_mag.action_status = 'C'
91: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
87: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
88: AND paa_mag.assignment_action_id = pai.locked_action_id
89: AND paa.action_status = 'C'
90: AND paa_mag.action_status = 'C'
91: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
92: ORDER BY ppf.last_name,
93: ppf.first_name,
94: ppf.middle_names;
95: /**************************************************************************/
95: /**************************************************************************/
96: CURSOR mag_t4_cancel_asg_actions IS
97: SELECT
98: 'TRANSFER_ACT_ID=P',
99: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
100: FROM
101: dual;
102: /**************************************************************************/
103: PROCEDURE get_report_parameters(