[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: /*SELECT distinct
24: 'PAYROLL_ACTION_ID=P',
25: ppa1.payroll_action_id,
36: ppa.payroll_action_id = paa.payroll_action_id
37: AND hoi.org_information_context = 'Fed Magnetic Reporting'
38: AND hoi.organization_id = paa1.tax_unit_id
39: AND hoi.org_information1 = 'Y'
40: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
41: AND int.locking_action_id = paa.assignment_action_id
42: AND paa1.assignment_action_id = int.locked_action_id
43: AND ppa1.payroll_action_id = paa1.payroll_action_id
44: AND ppa1.report_type in ('T4A','CAEOY_T4A_AMEND_PP')
64: pay_action_interlocks int,
65: hr_organization_information hoi1
66: WHERE paa.payroll_action_id = ppa.payroll_action_id
67: AND hoi1.organization_id = paa1.tax_unit_id
68: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
69: AND int.locking_action_id = paa.assignment_action_id
70: AND paa1.assignment_action_id = int.locked_action_id
71: AND ppa1.payroll_action_id = paa1.payroll_action_id
72: AND hoi1.org_information11 =pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE_ID')
68: AND ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
69: AND int.locking_action_id = paa.assignment_action_id
70: AND paa1.assignment_action_id = int.locked_action_id
71: AND ppa1.payroll_action_id = paa1.payroll_action_id
72: AND hoi1.org_information11 =pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE_ID')
73: AND hoi1.org_information5 like '%T4A%'
74: AND hoi1.org_information_context = 'Canada Employer Identification'
75: AND ppa1.report_type in ('T4A','CAEOY_T4A_AMEND_PP')
76: AND to_char(ppa.effective_date
73: AND hoi1.org_information5 like '%T4A%'
74: AND hoi1.org_information_context = 'Canada Employer Identification'
75: AND ppa1.report_type in ('T4A','CAEOY_T4A_AMEND_PP')
76: AND to_char(ppa.effective_date
77: ,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
78: AND to_char(ppa.effective_date
79: ,'DD-MM') = '31-12'
80: AND fdi.user_name = 'CAEOY_EMPLOYER_NAME'
81: AND ppa1.payroll_action_id = fai.context1
100: pay_assignment_actions paa,
101: pay_payroll_actions ppa,
102: pay_assignment_actions paa_mag
103: WHERE
104: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
105: AND paa.payroll_action_id = ppa.payroll_action_id
106: AND pai.locking_action_id = paa.assignment_action_id
107: AND paf.assignment_id = paa.assignment_id
108: AND ppf.person_id = paf.person_id
105: AND paa.payroll_action_id = ppa.payroll_action_id
106: AND pai.locking_action_id = paa.assignment_action_id
107: AND paf.assignment_id = paa.assignment_id
108: AND ppf.person_id = paf.person_id
109: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
110: between paf.effective_start_date and paf.effective_end_date
111: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
112: between ppf.effective_start_date and ppf.effective_end_date
113: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
107: AND paf.assignment_id = paa.assignment_id
108: AND ppf.person_id = paf.person_id
109: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
110: between paf.effective_start_date and paf.effective_end_date
111: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
112: between ppf.effective_start_date and ppf.effective_end_date
113: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
114: AND paa_mag.assignment_action_id = pai.locked_action_id
115: AND paa.action_status = 'C'
109: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
110: between paf.effective_start_date and paf.effective_end_date
111: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
112: between ppf.effective_start_date and ppf.effective_end_date
113: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
114: AND paa_mag.assignment_action_id = pai.locked_action_id
115: AND paa.action_status = 'C'
116: AND paa_mag.action_status = 'C'
117: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
113: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
114: AND paa_mag.assignment_action_id = pai.locked_action_id
115: AND paa.action_status = 'C'
116: AND paa_mag.action_status = 'C'
117: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
118: ORDER BY
119: ppf.last_name,
120: ppf.first_name,
121: ppf.middle_names;
123: /**************************************************************************/
124: CURSOR mag_t4a_cancel_asg_actions IS
125: SELECT
126: 'TRANSFER_ACT_ID=P',
127: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
128: FROM
129: dual;
130:
131: /**************************************************************************/