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

Line 37: and ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

33: pay_assignment_actions paa1,
34: pay_action_interlocks int
35: where
36: ppa.payroll_action_id = paa.payroll_action_id
37: and ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
38: and int.locking_action_id = paa.assignment_action_id
39: and paa1.assignment_action_id = int.locked_action_id
40: and ppa1.payroll_action_id = paa1.payroll_action_id
41: and ppa1.report_type in ('RL1','CAEOY_RL1_AMEND_PP')

Line 50: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'));

46: 'PAYROLL_ACTION_ID=P',
47: ppa.payroll_action_id
48: from
49: pay_payroll_actions ppa
50: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'));
51:
52: --
53: -- Used by Magnetic RL1 (RL1 format).
54: --

Line 62: 'PAYROLL_ACTION_ID=C',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),

58: --
59:
60: CURSOR mag_rl1_employer IS
61: select
62: 'PAYROLL_ACTION_ID=C',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
63: 'PAYROLL_ACTION_ID=P',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
64: from dual;
65:
66:

Line 63: 'PAYROLL_ACTION_ID=P',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))

59:
60: CURSOR mag_rl1_employer IS
61: select
62: 'PAYROLL_ACTION_ID=C',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
63: 'PAYROLL_ACTION_ID=P',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
64: from dual;
65:
66:
67: --

Line 88: ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

84: pay_assignment_actions paa,
85: pay_payroll_actions ppa,
86: pay_assignment_actions paa_mag
87: WHERE
88: ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
89: AND paa.payroll_action_id = ppa.payroll_action_id
90: AND pai.locking_action_id = paa.assignment_action_id
91: AND paf.assignment_id = paa.assignment_id
92: AND ppf.person_id = paf.person_id

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

89: AND paa.payroll_action_id = ppa.payroll_action_id
90: AND pai.locking_action_id = paa.assignment_action_id
91: AND paf.assignment_id = paa.assignment_id
92: AND ppf.person_id = paf.person_id
93: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
94: between paf.effective_start_date and paf.effective_end_date
95: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
96: between ppf.effective_start_date and ppf.effective_end_date
97: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

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

91: AND paf.assignment_id = paa.assignment_id
92: AND ppf.person_id = paf.person_id
93: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
94: between paf.effective_start_date and paf.effective_end_date
95: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
96: between ppf.effective_start_date and ppf.effective_end_date
97: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
98: AND paa_mag.assignment_action_id = pai.locked_action_id
99: ORDER BY

Line 97: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

93: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
94: between paf.effective_start_date and paf.effective_end_date
95: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
96: between ppf.effective_start_date and ppf.effective_end_date
97: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
98: AND paa_mag.assignment_action_id = pai.locked_action_id
99: ORDER BY
100: ppf.last_name,ppf.first_name,ppf.middle_names;
101:

Line 162: SELECT 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

158: PROCEDURE XML_EMPLOYER_RECORD;
159:
160: CURSOR rl1_asg_actions
161: IS
162: SELECT 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
163: FROM DUAL;
164:
165: END pay_ca_rl1_can_mag;