APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_MAGTAPE_GENERIC

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

29: SELECT 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
30: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
31: FROM hr_organization_information hoi,
32: pay_payroll_actions ppa
33: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
34: AND hoi.org_information_context='Prov Reporting Est'
35: AND ppa.report_type = 'CAEOY_RL2_AMEND_PP' -- RL2 Amendment Archiver Report Type
36: AND to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
37: AND to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

Line 37: AND to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

33: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
34: AND hoi.org_information_context='Prov Reporting Est'
35: AND ppa.report_type = 'CAEOY_RL2_AMEND_PP' -- RL2 Amendment Archiver Report Type
36: AND to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
37: AND to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
38: AND to_char(ppa.effective_date,'DD-MM')= '31-12'
39: GROUP BY
40: 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
41: 'PAYROLL_ACTION_ID=P';

Line 59: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

55: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
56: FROM pay_payroll_actions ppa,
57: hr_organization_information hoi
58: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
59: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
60: AND hoi.org_information_context='Prov Reporting Est'
61: AND to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
62: AND ppa.action_status = 'C'
63: AND to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

Line 63: AND to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

59: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
60: AND hoi.org_information_context='Prov Reporting Est'
61: AND to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
62: AND ppa.action_status = 'C'
63: AND to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
64: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
65: AND ppa.report_type = 'CAEOY_RL2_AMEND_PP'
66: GROUP BY
67: 'BUSINESS_GROUP_ID=C',ppa.business_group_id,

Line 93: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

89: pay_payroll_actions ppa,
90: pay_assignment_actions paa_arch,
91: pay_payroll_actions ppa_arch
92: WHERE ppa.payroll_action_id =
93: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
94: AND paa.payroll_action_id = ppa.payroll_action_id
95: AND pai.locking_action_id = paa.assignment_action_id
96: AND paf.assignment_id = paa.assignment_id
97: AND ppf.person_id = paf.person_id

Line 98: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between

94: AND paa.payroll_action_id = ppa.payroll_action_id
95: AND pai.locking_action_id = paa.assignment_action_id
96: AND paf.assignment_id = paa.assignment_id
97: AND ppf.person_id = paf.person_id
98: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
99: paf.effective_start_date and paf.effective_end_date
100: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
101: ppf.effective_start_date and ppf.effective_end_date
102: AND pin.action_context_id = pai.locked_action_id

Line 100: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between

96: AND paf.assignment_id = paa.assignment_id
97: AND ppf.person_id = paf.person_id
98: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
99: paf.effective_start_date and paf.effective_end_date
100: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
101: ppf.effective_start_date and ppf.effective_end_date
102: AND pin.action_context_id = pai.locked_action_id
103: AND pin.action_context_type = 'AAP'
104: AND pin.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'

Line 140: pay_magtape_generic.get_parameter_value(

136:
137: CURSOR rl2_amend_asg_actions
138: IS
139: SELECT 'TRANSFER_ACT_ID=P',
140: pay_magtape_generic.get_parameter_value(
141: 'TRANSFER_ACT_ID')
142: FROM DUAL;
143:
144: PROCEDURE xml_employee_record;