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

Line 47: from pay_assignment_actions paa,

43: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
44: rpaa.payroll_action_id,
45: rpaa.assignment_action_id,
46: paa.assignment_action_id
47: from pay_assignment_actions paa,
48: pay_payroll_actions ppa,
49: pay_assignment_actions rpaa,
50: pay_payroll_actions rppa
51: where paa.payroll_action_id = ppa.payroll_action_id

Line 49: pay_assignment_actions rpaa,

45: rpaa.assignment_action_id,
46: paa.assignment_action_id
47: from pay_assignment_actions paa,
48: pay_payroll_actions ppa,
49: pay_assignment_actions rpaa,
50: pay_payroll_actions rppa
51: where paa.payroll_action_id = ppa.payroll_action_id
52: and rppa.payroll_action_id = rpaa.payroll_action_id
53: and paa.assignment_action_id =

Line 57: pay_assignment_actions aa

53: and paa.assignment_action_id =
54: (select
55: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
56: from pay_payroll_actions pa,
57: pay_assignment_actions aa
58: where pa.action_type in ('U','P')
59: and aa.action_status = 'C'
60: and pa.payroll_action_id = aa.payroll_action_id
61: and aa.assignment_id = p_assignment_id

Line 67: from pay_assignment_actions aa,

63: and ppa.action_type in ('P', 'U')
64: and rpaa.assignment_id = p_assignment_id
65: and rpaa.action_sequence =
66: (select max(aa.action_sequence)
67: from pay_assignment_actions aa,
68: pay_action_interlocks loc
69: where loc.locked_action_id = aa.assignment_action_id
70: and aa.source_action_id is null
71: and loc.locking_action_id = paa.assignment_action_id); */

Line 81: from pay_assignment_actions paa,

77: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
78: rpaa.payroll_action_id,
79: rpaa.assignment_action_id,
80: paa.assignment_action_id
81: from pay_assignment_actions paa,
82: pay_payroll_actions ppa,
83: pay_assignment_actions rpaa,
84: pay_payroll_actions rppa
85: where paa.payroll_action_id = ppa.payroll_action_id

Line 83: pay_assignment_actions rpaa,

79: rpaa.assignment_action_id,
80: paa.assignment_action_id
81: from pay_assignment_actions paa,
82: pay_payroll_actions ppa,
83: pay_assignment_actions rpaa,
84: pay_payroll_actions rppa
85: where paa.payroll_action_id = ppa.payroll_action_id
86: and rppa.payroll_action_id = rpaa.payroll_action_id
87: and paa.assignment_action_id = curvar2

Line 92: from pay_assignment_actions aa,

88: and ppa.action_type in ('P', 'U')
89: and rpaa.assignment_id = p_assignment_id
90: and rpaa.action_sequence =
91: (select max(aa.action_sequence)
92: from pay_assignment_actions aa,
93: pay_action_interlocks loc
94: where loc.locked_action_id = aa.assignment_action_id
95: and aa.source_action_id is null
96: and loc.locking_action_id = paa.assignment_action_id);

Line 101: from pay_assignment_actions paa,

97: */
98: cursor cur_lat_action( curvar2 number)is
99: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
100: paa.assignment_action_id),16))
101: from pay_assignment_actions paa,
102: pay_action_interlocks loc
103: where loc.locked_action_id = paa.assignment_action_id
104: and paa.source_action_id IS NULL
105: and loc.locking_action_id = curvar2;

Line 110: from pay_assignment_actions rpaa,

106:
107: cursor cur_pact_details(curvar3 number) IS
108: select to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
109: rpaa.payroll_action_id
110: from pay_assignment_actions rpaa,
111: pay_payroll_actions rppa
112: where rpaa.payroll_action_id = rppa.payroll_action_id
113: and rpaa.assignment_action_id = curvar3;
114:

Line 125: pay_assignment_actions aa

121: ---in this case
122: cursor cur_assignment_action_id is
123: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
124: from pay_payroll_actions pa,
125: pay_assignment_actions aa
126: /*3922415- per_time_periods ptp */
127: where pa.action_type in ('Q','R','P','U')
128: and aa.action_status = 'C'
129: /*3922415-and ptp.payroll_id = pa.payroll_id*/

Line 141: from pay_payroll_actions,pay_assignment_actions

137: ---This is used to retrive the actio_type corresponding to the assignment action id found by prev cursor
138:
139: cursor cur_action_type(curvar3 number) is
140: select distinct action_type
141: from pay_payroll_actions,pay_assignment_actions
142: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
143: and assignment_action_id =curvar3;
144:
145:

Line 142: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id

138:
139: cursor cur_action_type(curvar3 number) is
140: select distinct action_type
141: from pay_payroll_actions,pay_assignment_actions
142: where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
143: and assignment_action_id =curvar3;
144:
145:
146:

Line 150: from pay_assignment_actions pac,

146:
147:
148: cursor csr_get_stand_run is
149: select pac.assignment_action_id
150: from pay_assignment_actions pac,
151: pay_run_types_f prt
152: where pac.run_type_id = prt.run_type_id
153: -- Added to be driven by index bug 2665701
154: and pac.assignment_id = p_assignment_id

Line 161: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

157:
158:
159: --
160: l_payroll_exists VARCHAR2(30);
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
162: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
163: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
164: l_date_earned VARCHAR2(30);
165: l_end_date date;

Line 162: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

158:
159: --
160: l_payroll_exists VARCHAR2(30);
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
162: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
163: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
164: l_date_earned VARCHAR2(30);
165: l_end_date date;
166: l_action_type varchar2(2);

Line 270: from pay_assignment_actions assact,

266: -- if the action is a prepayment return the latest run details locked
267: cursor csr_formula is
268: -- find what type of action this is
269: select pact.action_type , assact.assignment_id
270: from pay_assignment_actions assact,
271: pay_payroll_actions pact
272: where assact.assignment_action_id = p_assignment_action_id
273: and pact.payroll_action_id = assact.payroll_action_id;
274: cursor csr_formula_2 is

Line 277: from pay_assignment_actions assact,

273: and pact.payroll_action_id = assact.payroll_action_id;
274: cursor csr_formula_2 is
275: -- for prepayment action find the latest interlocked run
276: select assact.assignment_action_id
277: from pay_assignment_actions assact,
278: pay_action_interlocks loc
279: where loc.locking_action_id = p_assignment_action_id
280: and assact.assignment_action_id = loc.locked_action_id
281: and assact.source_action_id is null

Line 287: from pay_assignment_actions assact,

283: order by assact.action_sequence desc ;
284: cursor csr_formula_3 is
285: -- for run action check if its been prepaid
286: select assact.assignment_action_id
287: from pay_assignment_actions assact,
288: pay_payroll_actions pact,
289: pay_action_interlocks loc
290: where loc.locked_action_id = p_assignment_action_id
291: and assact.assignment_action_id = loc.locking_action_id

Line 297: from pay_assignment_actions pac,

293: and pact.action_type in ('P','U') /* prepayments only */
294: order by assact.action_sequence desc ;
295: cursor csr_get_stand_run is
296: select pac.assignment_action_id
297: from pay_assignment_actions pac,
298: pay_run_types_f prt
299: where pac.run_type_id = prt.run_type_id
300: -- Added to be driven by index bug 2665701
301: and pac.assignment_id = p_assignment_id

Line 307: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

303: and prt.run_method='N';
304: --
305: l_action_type varchar2(1);
306: --
307: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
308: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
309: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
310: --
311: begin

Line 308: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

304: --
305: l_action_type varchar2(1);
306: --
307: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
308: l_run_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
309: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
310: --
311: begin
312: --