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

Line 92: pay_assignment_actions paa

88: where exists(
89: select 1
90: from pay_run_results prr,
91: pay_element_entries_f pee,
92: pay_assignment_actions paa
93: where pee.creator_id = p_creator_id
94: and paa.assignment_id = pee.assignment_id
95: and paa.assignment_action_id = p_creator_id
96: and pee.creator_type = 'R'

Line 117: pay_assignment_actions paa

113: where exists(
114: select 1
115: from pay_run_results prr,
116: pay_element_entries_f pee,
117: pay_assignment_actions paa
118: where pee.creator_id = p_creator_id
119: and paa.assignment_id = pee.assignment_id
120: and paa.assignment_action_id = p_creator_id
121: and (pee.creator_type = 'RR' or pee.creator_type = 'EE')

Line 142: FROM pay_assignment_actions paa,

138: BEGIN
139:
140: SELECT NVL(org.org_information4, 'N')
141: INTO l_use_advanced_retropay
142: FROM pay_assignment_actions paa,
143: hr_organization_information org,
144: per_all_assignments asg
145: WHERE paa.assignment_action_id = p_creator_id
146: AND paa.assignment_id = asg.assignment_id

Line 205: pay_assignment_actions paa,

201: l_result_status PAY_RUN_RESULTS.STATUS%TYPE;
202: CURSOR csr_result_status IS
203: select prr.status
204: from pay_payroll_actions ppa,
205: pay_assignment_actions paa,
206: pay_run_results prr
207: where prr.source_id = p_element_entry_id
208: --
209: -- Necessary to specify source_type because source_type of

Line 259: pay_assignment_actions paa,

255: ppa.payroll_action_id,
256: ppa.action_type,
257: ppa.effective_date
258: from pay_payroll_actions ppa,
259: pay_assignment_actions paa,
260: pay_action_interlocks pai
261: where pai.locked_action_id = p_locked_action_id
262: and paa.assignment_action_id = pai.locking_action_id
263: and ppa.payroll_action_id = paa.payroll_action_id

Line 273: pay_assignment_actions paa,

269: ppa.payroll_action_id,
270: ppa.action_type,
271: ppa.effective_date
272: from pay_payroll_actions ppa,
273: pay_assignment_actions paa,
274: pay_action_interlocks pai
275: where pai.locked_action_id = p_locked_action_id
276: and paa.assignment_action_id = pai.locking_action_id
277: and ppa.payroll_action_id = paa.payroll_action_id

Line 281: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_FK2)

277: and ppa.payroll_action_id = paa.payroll_action_id
278: and ppa.action_type in ('P','U');
279: Cursor csr_payment_lock_action is
280: select /*+ ORDERED
281: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_FK2)
282: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
283: paa.assignment_action_id,
284: paa.action_status,
285: paa.object_version_number,

Line 289: from pay_assignment_actions paa,

285: paa.object_version_number,
286: ppa.payroll_action_id,
287: ppa.action_type,
288: ppa.effective_date
289: from pay_assignment_actions paa,
290: pay_payroll_actions ppa
291: where paa.pre_payment_id = p_locked_action_id
292: and ppa.payroll_action_id = paa.payroll_action_id
293: and not exists(

Line 296: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK)

292: and ppa.payroll_action_id = paa.payroll_action_id
293: and not exists(
294: select /*+ ORDERED
295: INDEX(PAI PAY_ACTION_INTERLOCKS_FK2)
296: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK)
297: INDEX(PPA2 PAY_PAYROLL_ACTIONS_PK) */
298: NULL
299: from pay_action_interlocks pai,
300: pay_assignment_actions paa2,

Line 300: pay_assignment_actions paa2,

296: INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK)
297: INDEX(PPA2 PAY_PAYROLL_ACTIONS_PK) */
298: NULL
299: from pay_action_interlocks pai,
300: pay_assignment_actions paa2,
301: pay_payroll_actions ppa2
302: where pai.locked_action_id = paa.assignment_action_id
303: and paa2.assignment_action_id = pai.locking_action_id
304: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 350: pay_assignment_actions paa,

346: /* When not locked, that means the following statement returns no rows,
347: max(decode(paa.action_status,'C',NULL,'E',2,1)) returns NULL. */
348: decode(max(decode(paa.action_status,'C',NULL,'E',2,1)),NULL,'C',1,'I','E')
349: from pay_payroll_actions ppa,
350: pay_assignment_actions paa,
351: pay_action_interlocks pai
352: where pai.locked_action_id = p_locked_action_id
353: and paa.assignment_action_id = pai.locking_action_id
354: and ppa.payroll_action_id = paa.payroll_action_id

Line 361: pay_assignment_actions paa2,

357: /* This select statement returns only 1 row. */
358: select decode(count(decode(ppa2.payroll_action_id,NULL,paa.assignment_action_id,NULL)),count(distinct ppp.pre_payment_id),'C',0,'U','I'),
359: decode(max(decode(decode(ppa2.payroll_action_id,NULL,paa.action_status,NULL),'C',NULL,NULL,NULL,'E',2,1)),NULL,'C',1,'I','E')
360: from pay_payroll_actions ppa2,
361: pay_assignment_actions paa2,
362: pay_action_interlocks pai,
363: pay_assignment_actions paa,
364: pay_pre_payments ppp
365: where ppp.assignment_action_id = p_locked_action_id

Line 363: pay_assignment_actions paa,

359: decode(max(decode(decode(ppa2.payroll_action_id,NULL,paa.action_status,NULL),'C',NULL,NULL,NULL,'E',2,1)),NULL,'C',1,'I','E')
360: from pay_payroll_actions ppa2,
361: pay_assignment_actions paa2,
362: pay_action_interlocks pai,
363: pay_assignment_actions paa,
364: pay_pre_payments ppp
365: where ppp.assignment_action_id = p_locked_action_id
366: and paa.pre_payment_id(+) = ppp.pre_payment_id
367: /* "H"(Cheque) action can be locked by "D"(Void) only once. */

Line 496: -- This procedure locks pay_assignment_actions table for "ROLLBACK" or

492: PROCEDURE lock_row(
493: p_assignment_action_id IN NUMBER,
494: p_object_version_number IN NUMBER)
495: -------------------------------------------------------------------------------
496: -- This procedure locks pay_assignment_actions table for "ROLLBACK" or
497: -- "MARK FOR RETRY".
498: -------------------------------------------------------------------------------
499: IS
500: l_object_version_number NUMBER;

Line 503: from pay_assignment_actions paa

499: IS
500: l_object_version_number NUMBER;
501: CURSOR csr_obj IS
502: select paa.object_version_number
503: from pay_assignment_actions paa
504: where paa.assignment_action_id=p_assignment_action_id
505: for update;
506: BEGIN
507: open csr_obj;

Line 553: from pay_assignment_actions

549: -- in current payroll_action_id.
550: --
551: select count(*)
552: into l_count
553: from pay_assignment_actions
554: where payroll_action_id = p_payroll_action_id
555: and rownum <= 2;
556: --
557: -- Rollback/Mark for Retry at assignment action level

Line 599: pay_assignment_actions paa

595: ppa.payroll_id,
596: ppa.consolidation_set_id,
597: ppa.time_period_id
598: from pay_payroll_actions ppa,
599: pay_assignment_actions paa
600: where paa.assignment_action_id = p_assignment_action_id
601: and ppa.payroll_action_id = paa.payroll_action_id;
602: l_rec csr_assact%ROWTYPE;
603: BEGIN