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.PYCADAR_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 330: from pay_action_interlocks pai_mag,

326: select 1
327: from dual
328: where exists
329: (select 1
330: from pay_action_interlocks pai_mag,
331: pay_assignment_actions paa_mag,
332: pay_payroll_actions ppa_mag
333: where pai_mag.locked_action_id = cp_prepayment_action_id
334: and pai_mag.locking_Action_id = paa_mag.assignment_action_id

Line 344: from pay_action_interlocks pai,

340: /* Bug 14061942 : Added to check if payment is voided. */
341: and not exists
342: (
343: select 1
344: from pay_action_interlocks pai,
345: pay_assignment_actions paa,
346: pay_payroll_actions ppa
347: where pai.locked_action_id = paa_mag.assignment_action_id
348: and pai.locking_Action_id = paa.assignment_action_id

Line 463: from pay_action_interlocks int2,

459: and popm.defined_balance_id IS NOT NULL)
460: -- and is not a reversal.
461: AND NOT EXISTS
462: ( Select ' '
463: from pay_action_interlocks int2,
464: pay_action_interlocks int4,
465: pay_assignment_actions paa4,
466: pay_payroll_actions ppa_run, --- RUN
467: pay_payroll_actions pact4, --- Reversal

Line 464: pay_action_interlocks int4,

460: -- and is not a reversal.
461: AND NOT EXISTS
462: ( Select ' '
463: from pay_action_interlocks int2,
464: pay_action_interlocks int4,
465: pay_assignment_actions paa4,
466: pay_payroll_actions ppa_run, --- RUN
467: pay_payroll_actions pact4, --- Reversal
468: pay_assignment_actions paa_run --- RUN

Line 541: from pay_action_interlocks int2,

537: and pos.person_id between stperson and endperson
538: and (paf1.payroll_id = ppa_dar.payroll_id or ppa_dar.payroll_id is null)
539: and not exists
540: ( select ''
541: from pay_action_interlocks int2,
542: pay_action_interlocks int3,
543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal

Line 542: pay_action_interlocks int3,

538: and (paf1.payroll_id = ppa_dar.payroll_id or ppa_dar.payroll_id is null)
539: and not exists
540: ( select ''
541: from pay_action_interlocks int2,
542: pay_action_interlocks int3,
543: pay_assignment_actions paa4,
544: pay_payroll_actions ppa_run, --- RUN
545: pay_payroll_actions pact4, --- Reversal
546: pay_assignment_actions paa_run, --- RUN

Line 568: from pay_action_interlocks pai

564: ** assignment action for each pre-payment.
565: *****************************************************************/
566: cursor c_pre_payments (cp_dd_action_id in number) is
567: select locked_action_id
568: from pay_action_interlocks pai
569: where pai.locking_action_id = cp_dd_action_id; --Direct Deposit dd
570:
571: /*****************************************************************
572: ** This cursor will get all the source actions for which the

Line 585: from pay_action_interlocks pai,

581: order by ppp.source_action_id;
582:
583: cursor c_payroll_run (cp_pre_pymt_action_id in number) is
584: select assignment_action_id
585: from pay_action_interlocks pai,
586: pay_assignment_actions paa
587: where pai.locking_action_id = cp_pre_pymt_action_id
588: and paa.assignment_Action_id = pai.locked_action_id
589: and paa.run_type_id is null

Line 690: from pay_action_interlocks int2,

686: )
687: and not exists
688: (
689: Select ''''
690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal

Line 691: pay_action_interlocks int3,

687: and not exists
688: (
689: Select ''''
690: from pay_action_interlocks int2,
691: pay_action_interlocks int3,
692: pay_assignment_actions paa4,
693: pay_payroll_actions ppa_run, --- RUN
694: pay_payroll_actions pact4, --- Reversal
695: pay_assignment_actions paa_run, --- RUN

Line 932: pay_action_interlocks pai_pre

928: paa_pyarch.tax_unit_id
929: from pay_payroll_actions ppa_pyarch,
930: pay_assignment_actions paa_pyarch,
931: per_assignments_f paf,
932: pay_action_interlocks pai_pre
933: where ppa_pyarch.report_type = 'PY_ARCHIVER'
934: and ppa_pyarch.report_category = 'RT'
935: and ppa_pyarch.report_qualifier = 'PYCAPYAR'
936: /* and cp_deposit_end_date between ppa_pyarch.start_date

Line 973: from pay_action_interlocks pai_run, --Pre > Run

969: cp_deposit_end_date,
970: cp_consolidation_set_id) = 'Y'
971: and not exists
972: (Select 1
973: from pay_action_interlocks pai_run, --Pre > Run
974: pay_action_interlocks pai_rev, --Run > Rev
975: pay_assignment_actions paa_rev, --Rev
976: pay_payroll_actions ppa_rev --Rev
977: where pai_run.locking_action_id = pai_pre.locked_action_id

Line 974: pay_action_interlocks pai_rev, --Run > Rev

970: cp_consolidation_set_id) = 'Y'
971: and not exists
972: (Select 1
973: from pay_action_interlocks pai_run, --Pre > Run
974: pay_action_interlocks pai_rev, --Run > Rev
975: pay_assignment_actions paa_rev, --Rev
976: pay_payroll_actions ppa_rev --Rev
977: where pai_run.locking_action_id = pai_pre.locked_action_id
978: and pai_rev.locked_action_id = pai_run.locked_action_id

Line 1007: from pay_action_interlocks pai,

1003: and net_pay.pre_payment_id is not null
1004: and not exists
1005: (
1006: select 1
1007: from pay_action_interlocks pai,
1008: pay_assignment_actions paa,
1009: pay_payroll_actions ppa
1010: where pai.locked_action_id = paa_mag.assignment_action_id
1011: and pai.locking_Action_id = paa.assignment_action_id

Line 1548: from pay_action_interlocks paci,

1544: ** we get it from interlocks.
1545: ****************************************************************/
1546: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
1547: select paa.assignment_action_id
1548: from pay_action_interlocks paci,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa
1551: where paci.locking_action_id = cp_assignment_action_id
1552: and paa.assignment_action_id = paci.locked_action_id

Line 1565: from pay_action_interlocks pai_run,

1561: ** means there is a seperate check.
1562: * ***************************************************************/
1563: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
1564: select paa_pre.assignment_action_id
1565: from pay_action_interlocks pai_run,
1566: pay_action_interlocks pai_pre,
1567: pay_assignment_actions paa_pre,
1568: pay_payroll_actions ppa_pre
1569: where pai_run.locking_action_id = cp_assignment_action_id

Line 1566: pay_action_interlocks pai_pre,

1562: * ***************************************************************/
1563: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
1564: select paa_pre.assignment_action_id
1565: from pay_action_interlocks pai_run,
1566: pay_action_interlocks pai_pre,
1567: pay_assignment_actions paa_pre,
1568: pay_payroll_actions ppa_pre
1569: where pai_run.locking_action_id = cp_assignment_action_id
1570: and pai_pre.locked_action_id = pai_run.locked_action_id

Line 1618: from pay_action_interlocks pai_run, --Pre > Run

1614: INTO lv_rev_run_exists
1615: FROM dual
1616: where exists
1617: (Select /*+ ORDERED */ 1
1618: from pay_action_interlocks pai_run, --Pre > Run
1619: pay_action_interlocks pai_rev, --Run > Rev
1620: pay_assignment_actions paa_rev, --Rev
1621: pay_payroll_actions ppa_rev --Rev
1622: where pai_run.locking_action_id = ln_prepay_action_id

Line 1619: pay_action_interlocks pai_rev, --Run > Rev

1615: FROM dual
1616: where exists
1617: (Select /*+ ORDERED */ 1
1618: from pay_action_interlocks pai_run, --Pre > Run
1619: pay_action_interlocks pai_rev, --Run > Rev
1620: pay_assignment_actions paa_rev, --Rev
1621: pay_payroll_actions ppa_rev --Rev
1622: where pai_run.locking_action_id = ln_prepay_action_id
1623: and pai_rev.locked_action_id = pai_run.locked_action_id