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_PAYROLL_ACTIONS

Line 194: -- in the period with PAY_PAYROLL_ACTIONS.effective_date between

190: p_effective_start_date IN DATE,
191: p_effective_end_date IN DATE) RETURN VARCHAR2
192: -------------------------------------------------------------------------------
193: -- Returns 'Y' or 'N' which indicates specified entry is processed or not
194: -- in the period with PAY_PAYROLL_ACTIONS.effective_date between
195: -- p_effective_start_date and p_effective_end_date.
196: -- If the entry is processed once without reversal, then returns 'Y'.
197: -- Even if the entry is deleted, this function returns correct value.
198: -------------------------------------------------------------------------------

Line 204: from pay_payroll_actions ppa,

200: l_entry_processed VARCHAR2(1);
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: --

Line 258: from pay_payroll_actions ppa,

254: paa.object_version_number,
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

Line 272: from pay_payroll_actions ppa,

268: paa.object_version_number,
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

Line 282: INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */

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,
286: ppa.payroll_action_id,

Line 290: pay_payroll_actions ppa

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(
294: select /*+ ORDERED

Line 297: INDEX(PPA2 PAY_PAYROLL_ACTIONS_PK) */

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,
301: pay_payroll_actions ppa2

Line 301: pay_payroll_actions ppa2

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
305: and ppa2.action_type = 'D');

Line 349: from pay_payroll_actions ppa,

345: select decode(count(*),0,'U','C'),
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

Line 360: from pay_payroll_actions ppa2,

356: Cursor csr_prepay_lock_status is
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

Line 591: select pay_payroll_actions_s.nextval PAYROLL_ACTION_ID,

587: -- with the same payroll_id, consolidation_set_id and effective_date.
588: -------------------------------------------------------------------------------
589: IS
590: CURSOR csr_assact IS
591: select pay_payroll_actions_s.nextval PAYROLL_ACTION_ID,
592: ppa.business_group_id,
593: ppa.effective_date,
594: ppa.date_earned,
595: ppa.payroll_id,

Line 598: from pay_payroll_actions ppa,

594: ppa.date_earned,
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;

Line 613: insert into pay_payroll_actions(

609: close csr_assact;
610: --
611: -- Insert "Reversal" payroll action.
612: --
613: insert into pay_payroll_actions(
614: PAYROLL_ACTION_ID,
615: ACTION_TYPE,
616: BUSINESS_GROUP_ID,
617: EFFECTIVE_DATE,