eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL2_MAG dependencies on PAY_MAGTAPE_GENERIC

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

43: SELECT 'BUSINESS_GROUP_ID=C',ppa.business_group_id,
44: 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id
45: FROM hr_organization_information hoi,
46: pay_payroll_actions ppa
47: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
48: AND hoi.org_information_context='Prov Reporting Est'
49: AND ppa.report_type = 'RL2' -- RL2 Archiver Report Type
50: AND to_char(hoi.organization_id) =
51: substr(ppa.legislative_parameters,

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

49: AND ppa.report_type = 'RL2' -- RL2 Archiver Report Type
50: AND to_char(hoi.organization_id) =
51: substr(ppa.legislative_parameters,
52: instr(ppa.legislative_parameters,'PRE_ORGANIZATION_ID=')+LENGTH('PRE_ORGANIZATION_ID='))
53: AND to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
54: AND to_char(ppa.effective_date,'DD-MM')= '31-12';
55:
56: --
57: -- Used by Magnetic RL2 (RL2 format).

Line 72: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

68: 'PAYROLL_ACTION_ID=P',ppa.payroll_action_id
69: FROM pay_payroll_actions ppa,
70: hr_organization_information hoi
71: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
72: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
73: AND hoi.org_information_context='Prov Reporting Est'
74: AND to_char(hoi.organization_id) =
75: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
76: AND ppa.action_status = 'C'

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

73: AND hoi.org_information_context='Prov Reporting Est'
74: AND to_char(hoi.organization_id) =
75: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
76: AND ppa.action_status = 'C'
77: AND to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
78: AND to_char(ppa.effective_date,'DD-MM') = '31-12'
79: AND ppa.report_type = 'RL2';
80:
81: --

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

98: pay_assignment_actions paa,
99: pay_payroll_actions ppa,
100: pay_assignment_actions paa_arch
101: WHERE ppa.payroll_action_id =
102: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
103: AND paa.payroll_action_id = ppa.payroll_action_id
104: AND pai.locking_action_id = paa.assignment_action_id
105: AND paf.assignment_id = paa.assignment_id
106: AND ppf.person_id = paf.person_id

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

103: AND paa.payroll_action_id = ppa.payroll_action_id
104: AND pai.locking_action_id = paa.assignment_action_id
105: AND paf.assignment_id = paa.assignment_id
106: AND ppf.person_id = paf.person_id
107: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
108: paf.effective_start_date and paf.effective_end_date
109: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
110: ppf.effective_start_date and ppf.effective_end_date
111: AND pin.action_context_id = pai.locked_action_id

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

105: AND paf.assignment_id = paa.assignment_id
106: AND ppf.person_id = paf.person_id
107: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
108: paf.effective_start_date and paf.effective_end_date
109: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
110: ppf.effective_start_date and ppf.effective_end_date
111: AND pin.action_context_id = pai.locked_action_id
112: AND pin.action_context_type = 'AAP'
113: AND pin.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'

Line 116: to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))

112: AND pin.action_context_type = 'AAP'
113: AND pin.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
114: AND paa_arch.assignment_action_id = pai.locked_action_id
115: AND paa_arch.payroll_action_id =
116: to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
117: AND to_char(pin.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
118: ORDER BY ppf.last_name,ppf.first_name,ppf.middle_names;
119:
120: PROCEDURE get_report_parameters

Line 185: pay_magtape_generic.get_parameter_value(

181: RETURN NUMBER;
182: CURSOR rl2_asg_actions
183: IS
184: SELECT 'TRANSFER_ACT_ID=P',
185: pay_magtape_generic.get_parameter_value(
186: 'TRANSFER_ACT_ID')
187: FROM DUAL;
188:
189: cursor main_block is

Line 197: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

193: cursor transfer_block is
194: select 'TRANSFER_ACT_ID=P', assignment_action_id
195: from pay_assignment_actions
196: where payroll_action_id =
197: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
198:
199: FUNCTION convert_special_char( p_data IN VARCHAR2)
200: RETURN VARCHAR2;
201: