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 51: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

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

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

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

Line 76: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

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

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

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

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

102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_assignment_actions paa_arch
105: WHERE ppa.payroll_action_id =
106: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
107: AND paa.payroll_action_id = ppa.payroll_action_id
108: AND pai.locking_action_id = paa.assignment_action_id
109: AND paf.assignment_id = paa.assignment_id
110: AND ppf.person_id = paf.person_id

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

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

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

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

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

116: AND pin.action_context_type = 'AAP'
117: AND pin.action_information_category = 'CAEOY RL2 EMPLOYEE INFO'
118: AND paa_arch.assignment_action_id = pai.locked_action_id
119: AND paa_arch.payroll_action_id =
120: to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
121: AND to_char(pin.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
122: ORDER BY ppf.last_name,ppf.first_name,ppf.middle_names;
123:
124: procedure store_further_information(p_assg_actid IN NUMBER);

Line 214: pay_magtape_generic.get_parameter_value(

210: RETURN NUMBER;
211: CURSOR rl2_asg_actions
212: IS
213: SELECT 'TRANSFER_ACT_ID=P',
214: pay_magtape_generic.get_parameter_value(
215: 'TRANSFER_ACT_ID')
216: FROM DUAL;
217:
218: cursor main_block is

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

223: cursor transfer_block is
224: select 'TRANSFER_ACT_ID=P', assignment_action_id
225: from pay_assignment_actions
226: where payroll_action_id =
227: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
228: */
229:
230: cursor transfer_block is
231: select 'TRANSFER_ACT_ID=P', assignment_action_id

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

235: per_all_people_f ppf,
236: per_all_assignments_f paf,
237: pay_assignment_actions paa1,
238: pay_payroll_actions ppa1
239: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: and paa1.payroll_action_id = ppa1.payroll_action_id
241: and paa1.assignment_id = paf.assignment_id
242: and paf.assignment_type = 'E'
243: and paf.primary_flag = 'Y'