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_RL1_AMEND_MAG dependencies on PAY_MAGTAPE_GENERIC

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

34: 'TRANSFER_CPP_MAX=P', pcli.information_value
35: FROM hr_organization_information hoi,
36: pay_payroll_actions PPA,
37: pay_ca_legislation_info pcli
38: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
39: and hoi.org_information_context='Prov Reporting Est'
40: and ppa.report_type ='CAEOY_RL1_AMEND_PP'
41: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
42: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

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

38: WHERE to_char(hoi.organization_id) = pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
39: and hoi.org_information_context='Prov Reporting Est'
40: and ppa.report_type ='CAEOY_RL1_AMEND_PP'
41: and to_char(hoi.organization_id) = pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters)
42: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
43: and to_char(ppa.effective_date,'DD-MM')= '31-12'
44: and pcli.information_type = 'MAX_CPP_EARNINGS'
45: and ppa.effective_date between pcli.start_date and pcli.end_date
46: GROUP BY

Line 66: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')

62: 'PAYROLL_ACTION_ID=P',MAX(ppa.payroll_action_id)
63: from pay_payroll_actions ppa,
64: hr_organization_information hoi
65: WHERE decode(hoi.org_information3,'Y',to_char(hoi.organization_id) ,hoi.org_information20) =
66: pay_magtape_generic.get_parameter_value('TRANSMITTER_PRE')
67: and hoi.org_information_context='Prov Reporting Est'
68: and to_char(hoi.organization_id) =
69: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
70: and ppa.action_status = 'C'

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

67: and hoi.org_information_context='Prov Reporting Est'
68: and to_char(hoi.organization_id) =
69: pay_ca_rl1_reg.get_parameter('PRE_ORGANIZATION_ID', ppa.legislative_parameters)
70: and ppa.action_status = 'C'
71: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
72: and to_char(ppa.effective_date,'DD-MM') = '31-12'
73: and ppa.report_type= 'CAEOY_RL1_AMEND_PP'
74: group by 'PAYROLL_ACTION_ID=C','PAYROLL_ACTION_ID=P';
75:

Line 99: to_number(pay_magtape_generic.get_parameter_value

95: pay_assignment_actions paa_arch,
96: pay_payroll_actions ppa_arch
97: WHERE
98: ppa.payroll_action_id =
99: to_number(pay_magtape_generic.get_parameter_value
100: ('TRANSFER_PAYROLL_ACTION_ID')) AND
101: paa.payroll_action_id = ppa.payroll_action_id AND
102: pai.locking_action_id = paa.assignment_action_id AND
103: paf.assignment_id = paa.assignment_id AND

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

101: paa.payroll_action_id = ppa.payroll_action_id AND
102: pai.locking_action_id = paa.assignment_action_id AND
103: paf.assignment_id = paa.assignment_id AND
104: ppf.person_id = paf.person_id AND
105: apps.pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
106: between
107: paf.effective_start_date and paf.effective_end_date AND
108: pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
109: between

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

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

Line 172: pay_magtape_generic.get_parameter_value(

168:
169: CURSOR rl1_amend_asg_actions
170: IS
171: SELECT 'TRANSFER_ACT_ID=P',
172: pay_magtape_generic.get_parameter_value(
173: 'TRANSFER_ACT_ID')
174: FROM DUAL;
175: /*************************************************/
176: CURSOR rl1xml_asg_actions

Line 179: pay_magtape_generic.get_parameter_value(

175: /*************************************************/
176: CURSOR rl1xml_asg_actions
177: IS
178: SELECT 'TRANSFER_ACT_ID=P',
179: pay_magtape_generic.get_parameter_value(
180: 'TRANSFER_ACT_ID')
181: FROM DUAL;
182:
183: cursor rl1xml_main_block is

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

187: cursor rl1xml_transfer_block is
188: select 'TRANSFER_ACT_ID=P', assignment_action_id
189: from pay_assignment_actions
190: where payroll_action_id =
191: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
192:
193: PROCEDURE RL1XML_emplyer_data(p_assact_id IN NUMBER
194: ,p_emplyr_final1 OUT NOCOPY VARCHAR2
195: ,p_emplyr_final2 OUT NOCOPY VARCHAR2