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

Line 133: from pay_assignment_actions paa,

129: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
130: rpaa.payroll_action_id,
131: rpaa.assignment_action_id,
132: paa.assignment_action_id
133: from pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_assignment_actions rpaa,
136: pay_payroll_actions rppa
137: where paa.payroll_action_id = ppa.payroll_action_id

Line 135: pay_assignment_actions rpaa,

131: rpaa.assignment_action_id,
132: paa.assignment_action_id
133: from pay_assignment_actions paa,
134: pay_payroll_actions ppa,
135: pay_assignment_actions rpaa,
136: pay_payroll_actions rppa
137: where paa.payroll_action_id = ppa.payroll_action_id
138: and rppa.payroll_action_id = rpaa.payroll_action_id
139: and paa.assignment_id = rpaa.assignment_id

Line 144: pay_assignment_actions aa

140: and paa.assignment_action_id =
141: (select
142: to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
143: from pay_payroll_actions pa,
144: pay_assignment_actions aa
145: where pa.action_type in ('U','P')
146: and aa.action_status IN ('C','S') --10376999
147: and pa.payroll_action_id = aa.payroll_action_id
148: and aa.assignment_id = p_assignment_id

Line 154: from pay_assignment_actions aa,

150: and ppa.action_type in ('P', 'U')
151: and rpaa.assignment_id = p_assignment_id
152: and rpaa.action_sequence =
153: (select max(aa.action_sequence)
154: from pay_assignment_actions aa,
155: pay_action_interlocks loc
156: where loc.locked_action_id = aa.assignment_action_id
157: and loc.locking_action_id = paa.assignment_action_id);
158:

Line 164: FROM pay_assignment_actions paa,

160: cursor csr_formula_2 is
161: SELECT /*+ USE_NL(paa, ppa) */
162: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
163: paa.assignment_action_id),16))
164: FROM pay_assignment_actions paa,
165: pay_payroll_actions ppa
166: WHERE
167: paa.assignment_id = p_assignment_id
168: AND ppa.payroll_action_id = paa.payroll_action_id

Line 178: pay_assignment_actions paa

174: cursor csr_formula_3(p_assig_act_id NUMBER) is
175: select to_char(nvl(ppa.date_earned,ppa.effective_date),'YYYY/MM/DD'),
176: paa.payroll_action_id
177: from pay_payroll_actions ppa,
178: pay_assignment_actions paa
179: where paa.assignment_action_id = p_assig_act_id
180: and ppa.payroll_action_id = paa.payroll_action_id;
181:
182: cursor csr_formula_4(p_assig_act_id NUMBER) is

Line 184: from pay_assignment_actions assact,

180: and ppa.payroll_action_id = paa.payroll_action_id;
181:
182: cursor csr_formula_4(p_assig_act_id NUMBER) is
183: select pact.action_type
184: from pay_assignment_actions assact,
185: pay_payroll_actions pact
186: where assact.assignment_action_id = p_assignment_action_id
187: and pact.payroll_action_id = assact.payroll_action_id;
188:

Line 191: from pay_assignment_actions assact,

187: and pact.payroll_action_id = assact.payroll_action_id;
188:
189: cursor csr_formula_5(p_assig_act_id NUMBER) is
190: select assact.assignment_action_id
191: from pay_assignment_actions assact,
192: pay_action_interlocks loc
193: where loc.locking_action_id = p_assignment_action_id
194: and assact.assignment_action_id = loc.locked_action_id
195: order by assact.action_sequence desc;

Line 258: from pay_assignment_actions assact,

254: -- if the action is a prepayment return the latest run details locked
255: cursor csr_formula is
256: -- find what type of action this is
257: select pact.action_type , assact.assignment_id
258: from pay_assignment_actions assact,
259: pay_payroll_actions pact
260: where assact.assignment_action_id = p_assignment_action_id
261: and pact.payroll_action_id = assact.payroll_action_id
262: ;

Line 266: from pay_assignment_actions assact,

262: ;
263: cursor csr_formula_2 is
264: -- for prepayment action find the latest interlocked run
265: select assact.assignment_action_id
266: from pay_assignment_actions assact,
267: pay_action_interlocks loc
268: where loc.locking_action_id = p_assignment_action_id
269: and assact.assignment_action_id = loc.locked_action_id
270: order by assact.action_sequence desc

Line 275: from pay_assignment_actions assact,

271: ;
272: cursor csr_formula_3 is
273: -- for run action check if its been prepaid
274: select assact.assignment_action_id
275: from pay_assignment_actions assact,
276: pay_payroll_actions pact,
277: pay_action_interlocks loc
278: where loc.locked_action_id = p_assignment_action_id
279: and assact.assignment_action_id = loc.locking_action_id

Line 288: from pay_assignment_actions assact,

284: cursor csr_formula_4 is
285: -- now find the date earned and payroll action of the run action
286: select pact.payroll_action_id,
287: to_char(nvl(pact.date_earned,pact.effective_date),'YYYY/MM/DD')
288: from pay_assignment_actions assact,
289: pay_payroll_actions pact
290: where assact.assignment_action_id = p_run_assignment_action_id
291: and pact.payroll_action_id = assact.payroll_action_id
292: ;