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_T4A_CANCEL_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 14: pay_assignment_actions paa

10: p_sqlstr := 'select distinct paaf.person_id
11: from per_all_assignments_f paaf,
12: pay_payroll_actions ppa,
13: pay_payroll_actions ppa1,
14: pay_assignment_actions paa
15: where ppa.payroll_action_id = paa.payroll_action_id
16: and paa.assignment_id = paaf.assignment_id
17: and ppa1.payroll_action_id = :payroll_action_id
18: and ppa.payroll_action_id =

Line 50: pay_assignment_actions paa,

46: per_all_assignments_f paaf,
47: pay_payroll_actions ppa,
48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,
51: pay_assignment_actions paa1,
52: pay_action_interlocks int
53: where
54: ppa.payroll_action_id = paa.payroll_action_id

Line 51: pay_assignment_actions paa1,

47: pay_payroll_actions ppa,
48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,
51: pay_assignment_actions paa1,
52: pay_action_interlocks int
53: where
54: ppa.payroll_action_id = paa.payroll_action_id
55: and paa.assignment_id = paaf.assignment_id

Line 69: from pay_action_interlocks pai, pay_assignment_actions paa2

65: and paa.action_status = 'C'
66: and paa1.action_status = 'C'
67: and paa.assignment_action_id
68: not in (select paa2.assignment_action_id
69: from pay_action_interlocks pai, pay_assignment_actions paa2
70: where paa2.assignment_action_id = pai.locked_action_id
71: and paa2.payroll_action_id =
72: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
73: )

Line 92: pay_assignment_actions paa,

88: per_all_assignments_f paaf,
89: pay_payroll_actions ppa,
90: pay_payroll_actions ppa1,
91: pay_payroll_actions ppa2,
92: pay_assignment_actions paa,
93: pay_assignment_actions paa1,
94: pay_action_interlocks int
95: where
96: ppa.payroll_action_id = paa.payroll_action_id

Line 93: pay_assignment_actions paa1,

89: pay_payroll_actions ppa,
90: pay_payroll_actions ppa1,
91: pay_payroll_actions ppa2,
92: pay_assignment_actions paa,
93: pay_assignment_actions paa1,
94: pay_action_interlocks int
95: where
96: ppa.payroll_action_id = paa.payroll_action_id
97: and paa.assignment_id = paaf.assignment_id

Line 119: pay_assignment_actions paa2

115: and paf.person_id = paaf.person_id)
116: and paa.assignment_action_id
117: not in (select paa2.assignment_action_id
118: from pay_action_interlocks pai,
119: pay_assignment_actions paa2
120: where paa2.assignment_action_id = pai.locked_action_id
121: and paa2.payroll_action_id =
122: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
123: )

Line 140: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--

136: l_assignment_action_id NUMBER;
137: l_tax_unit_id NUMBER;
138: lockingactid NUMBER;
139: lv_report_type pay_payroll_actions.report_type%TYPE ;
140: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
141: lv_fed_amend_flag VARCHAR2(5);
142: ln_t4a_amend_flag_ue_id NUMBER;
143: lv_flag_count NUMBER := 0;
144: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

Line 144: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;

140: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;--
141: lv_fed_amend_flag VARCHAR2(5);
142: ln_t4a_amend_flag_ue_id NUMBER;
143: lv_flag_count NUMBER := 0;
144: l_lockingactid_check pay_assignment_actions.assignment_action_id%TYPE;
145: l_payroll_act NUMBER;
146:
147: BEGIN
148: hr_utility.trace('+=========================================================+');

Line 202: SELECT pay_assignment_actions_s.nextval

198: hr_utility.trace('Person ID : '|| to_char(l_person_id));
199: hr_utility.trace('Tax Unit ID : '|| to_char(l_tax_unit_id));
200: hr_utility.trace('Effective End Date : '|| to_char(l_effective_end_date,'DD-Mon-YYYY'));
201: hr_utility.trace('x------------------------------------------------x');
202: SELECT pay_assignment_actions_s.nextval
203: INTO lockingactid
204: FROM dual;
205: hr_utility.trace('New T4A Cancel Action = ' ||to_char(lockingactid));
206: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 30);

Line 214: UPDATE pay_assignment_actions aa

210: ,p_chunk
211: ,l_tax_unit_id);
212: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 40);
213:
214: UPDATE pay_assignment_actions aa
215: SET aa.serial_number = to_char(l_person_id)
216: WHERE aa.assignment_action_id = lockingactid;
217:
218: hr_utility.set_location('pay_ca_t4a_cancel_mag.action_creation', 50);

Line 288: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;

284: l_trans_bus_no VARCHAR2(240) ;
285: l_bus_no VARCHAR2(240) ;
286: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
287: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
288: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
290: l_acc_info_flag CHAR(1);
291: l_trans_name VARCHAR2(240);
292: l_gre_name VARCHAR2(240);

Line 289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;

285: l_bus_no VARCHAR2(240) ;
286: l_trans_payid pay_payroll_actions.payroll_action_id%TYPE;
287: l_gre_payid pay_payroll_actions.payroll_action_id%TYPE;
288: l_gre_actid pay_assignment_actions.assignment_action_id%TYPE;
289: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
290: l_acc_info_flag CHAR(1);
291: l_trans_name VARCHAR2(240);
292: l_gre_name VARCHAR2(240);
293: l_bg_id NUMBER;

Line 693: from pay_assignment_actions paa,

689:
690: begin
691: select max(paa1.payroll_action_id)
692: into l_context1
693: from pay_assignment_actions paa,
694: pay_assignment_actions paa1,
695: pay_action_interlocks int
696: where int.locking_action_id = paa.assignment_action_id
697: and paa1.assignment_action_id = int.locked_action_id

Line 694: pay_assignment_actions paa1,

690: begin
691: select max(paa1.payroll_action_id)
692: into l_context1
693: from pay_assignment_actions paa,
694: pay_assignment_actions paa1,
695: pay_action_interlocks int
696: where int.locking_action_id = paa.assignment_action_id
697: and paa1.assignment_action_id = int.locked_action_id
698: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

Line 1220: FROM pay_assignment_actions paa,

1216: CURSOR c_get_payroll_asg_actid(p_assg_actid NUMBER) IS
1217: SELECT
1218: paa.assignment_action_id,
1219: paa.payroll_action_id
1220: FROM pay_assignment_actions paa,
1221: pay_payroll_actions ppa,
1222: pay_action_interlocks pai,
1223: pay_action_interlocks pai2
1224: WHERE pai.locking_action_id = p_assg_actid

Line 1236: pay_assignment_actions

1232: CURSOR c_get_person_id(p_mag_asg_action_id NUMBER) IS
1233: SELECT
1234: serial_number
1235: FROM
1236: pay_assignment_actions
1237: WHERE assignment_action_id = p_mag_asg_action_id;
1238:
1239: BEGIN
1240: hr_utility.trace('+==========================================================+');