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.

[Home] [Help]

APPS.PAY_CA_RL2_CAN_MAG dependencies on PAY_MAGTAPE_GENERIC

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

24: 'PAYROLL_ACTION_ID=P',
25: ppa.payroll_action_id
26: from
27: pay_payroll_actions ppa
28: where ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'));
29: /* SELECT distinct
30: 'PAYROLL_ACTION_ID=P',
31: ppa1.payroll_action_id,
32: 'PAYROLL_ACTION_ID=C',

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

38: pay_assignment_actions paa1,
39: pay_action_interlocks int
40: where
41: ppa.payroll_action_id = paa.payroll_action_id
42: and ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
43: and int.locking_action_id = paa.assignment_action_id
44: and paa1.assignment_action_id = int.locked_action_id
45: and ppa1.payroll_action_id = paa1.payroll_action_id
46: and ppa1.report_type in ('RL2','CAEOY_RL2_AMEND_PP')

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

47: and ppa1.action_status = 'C';*/
48:
49: CURSOR mag_rl2_employer IS
50: select
51: 'PAYROLL_ACTION_ID=C',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
52: 'PAYROLL_ACTION_ID=P',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
53: from dual;
54:
55:

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

48:
49: CURSOR mag_rl2_employer IS
50: select
51: 'PAYROLL_ACTION_ID=C',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')),
52: 'PAYROLL_ACTION_ID=P',to_number(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
53: from dual;
54:
55:
56: CURSOR mag_rl2_employee IS

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

63: pay_assignment_actions paa,
64: pay_payroll_actions ppa,
65: pay_assignment_actions paa_mag
66: WHERE
67: ppa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
68: AND paa.payroll_action_id = ppa.payroll_action_id
69: AND pai.locking_action_id = paa.assignment_action_id
70: AND paf.assignment_id = paa.assignment_id
71: AND ppf.person_id = paf.person_id

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

68: AND paa.payroll_action_id = ppa.payroll_action_id
69: AND pai.locking_action_id = paa.assignment_action_id
70: AND paf.assignment_id = paa.assignment_id
71: AND ppf.person_id = paf.person_id
72: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
73: between paf.effective_start_date and paf.effective_end_date
74: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
75: between ppf.effective_start_date and ppf.effective_end_date
76: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))

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

70: AND paf.assignment_id = paa.assignment_id
71: AND ppf.person_id = paf.person_id
72: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
73: between paf.effective_start_date and paf.effective_end_date
74: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
75: between ppf.effective_start_date and ppf.effective_end_date
76: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
77: AND paa_mag.assignment_action_id = pai.locked_action_id
78: ORDER BY

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

72: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
73: between paf.effective_start_date and paf.effective_end_date
74: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
75: between ppf.effective_start_date and ppf.effective_end_date
76: AND paa_mag.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('PAY_ACT'))
77: AND paa_mag.assignment_action_id = pai.locked_action_id
78: ORDER BY
79: ppf.last_name,ppf.first_name,ppf.middle_names;
80:

Line 140: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

136:
137: CURSOR rl2_asg_actions
138: IS
139: SELECT 'TRANSFER_ACT_ID=P',
140: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
141: FROM DUAL;
142:
143: FUNCTION convert_special_char( p_data IN VARCHAR2)
144: RETURN VARCHAR2;