[Home] [Help]
46: CURSOR mag_rl1_transmitter IS
47: Select 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id,
48: 'TRANSFER_CPP_MAX=P', pcli.information_value
49: FROM hr_organization_information hoi,
50: pay_payroll_actions PPA,
51: pay_ca_legislation_info pcli
52: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
53: and hoi.org_information_context='Prov Reporting Est'
54: and ppa.report_type = 'RL1' -- RL1 Archiver Report Type
68: --
69: CURSOR mag_rl1_employer IS
70: select distinct 'PAYROLL_ACTION_ID=C',ppa.payroll_action_id,
71: 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id
72: from pay_payroll_actions ppa,
73: hr_organization_information hoi
74: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
75: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
76: and hoi.org_information_context='Prov Reporting Est'
98: per_all_people_f ppf,
99: per_all_assignments_f paf,
100: pay_action_interlocks pai,
101: pay_assignment_actions paa,
102: pay_payroll_actions ppa,
103: pay_assignment_actions paa_arch
104: WHERE
105: ppa.payroll_action_id =
106: to_number(pay_magtape_generic.get_parameter_value
240: hr_locations_all loc,
241: per_all_people_f ppf,
242: per_all_assignments_f paf,
243: pay_assignment_actions paa1,
244: pay_payroll_actions ppa1
245: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
246: and paa1.payroll_action_id = ppa1.payroll_action_id
247: and paa1.assignment_id = paf.assignment_id
248: and paf.assignment_type = 'E'