APPS.PAY_CA_RL1_MAG dependencies on PAY_MAGTAPE_GENERIC

Line 52: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

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
55: and to_char(hoi.organization_id) = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'PRE_ORGANIZATION_ID=')+LENGTH('PRE_ORGANIZATION_ID='))
56: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

Line 56: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

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
55: and to_char(hoi.organization_id) = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'PRE_ORGANIZATION_ID=')+LENGTH('PRE_ORGANIZATION_ID='))
56: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
57: and to_char(ppa.effective_date,'DD-MM')= '31-12'
58: and pcli.information_type = 'MAX_CPP_EARNINGS'
59: and ppa.effective_date between pcli.start_date and pcli.end_date;
60:

Line 75: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

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'
77: and to_char(hoi.organization_id) =
78: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
79: and ppa.action_status = 'C'

Line 80: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

76: and hoi.org_information_context='Prov Reporting Est'
77: and to_char(hoi.organization_id) =
78: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
79: and ppa.action_status = 'C'
80: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
81: and to_char(ppa.effective_date,'DD-MM') = '31-12'
82: and ppa.report_type = 'RL1';
83:
84: --

Line 106: to_number(pay_magtape_generic.get_parameter_value

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
107: ('TRANSFER_PAYROLL_ACTION_ID')) AND
108: paa.payroll_action_id = ppa.payroll_action_id AND
109: pai.locking_action_id = paa.assignment_action_id AND
110: paf.assignment_id = paa.assignment_id AND

Line 112: apps.pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)

108: paa.payroll_action_id = ppa.payroll_action_id AND
109: pai.locking_action_id = paa.assignment_action_id AND
110: paf.assignment_id = paa.assignment_id AND
111: ppf.person_id = paf.person_id AND
112: apps.pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
113: between
114: paf.effective_start_date and paf.effective_end_date AND
115: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
116: between

Line 115: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)

111: ppf.person_id = paf.person_id AND
112: apps.pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
113: between
114: paf.effective_start_date and paf.effective_end_date AND
115: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
116: between
117: ppf.effective_start_date and ppf.effective_end_date AND
118: paa_arch.payroll_action_id =
119: to_number(pay_magtape_generic.get_parameter_value

Line 119: to_number(pay_magtape_generic.get_parameter_value

115: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
116: between
117: ppf.effective_start_date and ppf.effective_end_date AND
118: paa_arch.payroll_action_id =
119: to_number(pay_magtape_generic.get_parameter_value
120: ('PAYROLL_ACTION_ID')) AND
121: paa_arch.assignment_action_id = pai.locked_action_id
122: ORDER BY
123: ppf.last_name,ppf.first_name,ppf.middle_names;

Line 221: pay_magtape_generic.get_parameter_value(

217:
218: CURSOR rl1_asg_actions
219: IS
220: SELECT 'TRANSFER_ACT_ID=P',
221: pay_magtape_generic.get_parameter_value(
222: 'TRANSFER_ACT_ID')
223: FROM DUAL;
224: /*************************************************/
225: CURSOR rl1xml_asg_actions

Line 228: pay_magtape_generic.get_parameter_value(

224: /*************************************************/
225: CURSOR rl1xml_asg_actions
226: IS
227: SELECT 'TRANSFER_ACT_ID=P',
228: pay_magtape_generic.get_parameter_value(
229: 'TRANSFER_ACT_ID')
230: FROM DUAL;
231:
232: cursor rl1xml_main_block is

Line 245: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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'
249: and paf.primary_flag = 'Y'