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_KW_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 443: pay_action_interlocks pai,

439: pay_payroll_actions appa,
440: pay_payroll_actions appa2,
441: pay_assignment_actions act,
442: pay_assignment_actions act1,
443: pay_action_interlocks pai,
444: per_all_assignments_f as1
445: WHERE ppa.payroll_action_id = p_payroll_action_id
446: AND appa.consolidation_set_id = p_consolidation_id
447: AND appa.effective_date BETWEEN l_canonical_start_date

Line 469: FROM pay_action_interlocks pai1,

465: AND l_canonical_end_date
466: -- Prepayments or Quickpay Prepayments
467: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
468: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
469: FROM pay_action_interlocks pai1,
470: pay_assignment_actions act2,
471: pay_payroll_actions appa3
472: WHERE pai1.locked_action_id = act.assignment_action_id
473: AND act2.assignment_action_id= pai1.locking_action_id

Line 479: FROM pay_action_interlocks pai1,

475: AND appa3.action_type = 'X'
476: AND appa3.action_status = 'C'
477: AND appa3.report_type = 'KW_ARCHIVE')
478: AND NOT EXISTS ( SELECT /*+ ORDERED */ NULL
479: FROM pay_action_interlocks pai1,
480: pay_assignment_actions act2,
481: pay_payroll_actions appa3
482: WHERE pai1.locked_action_id = act.assignment_action_id
483: AND act2.assignment_action_id= pai1.locking_action_id

Line 589: FROM pay_action_interlocks archive_intlck

585:
586: CURSOR csr_prepay_id IS
587: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
588: ,run_payact.date_earned date_earned
589: FROM pay_action_interlocks archive_intlck
590: ,pay_assignment_actions prepay_assact
591: ,pay_payroll_actions prepay_payact
592: ,pay_action_interlocks prepay_intlck
593: ,pay_assignment_actions run_assact

Line 592: ,pay_action_interlocks prepay_intlck

588: ,run_payact.date_earned date_earned
589: FROM pay_action_interlocks archive_intlck
590: ,pay_assignment_actions prepay_assact
591: ,pay_payroll_actions prepay_payact
592: ,pay_action_interlocks prepay_intlck
593: ,pay_assignment_actions run_assact
594: ,pay_payroll_actions run_payact
595: ,pay_assignment_actions archive_assact
596: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 612: FROM pay_action_interlocks archive_intlck

608: CURSOR csr_runact_id IS
609: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
610: ,run_payact.date_earned date_earned
611: ,run_payact.payroll_action_id run_payact_id
612: FROM pay_action_interlocks archive_intlck
613: ,pay_assignment_actions prepay_assact
614: ,pay_payroll_actions prepay_payact
615: ,pay_action_interlocks prepay_intlck
616: ,pay_assignment_actions run_assact

Line 615: ,pay_action_interlocks prepay_intlck

611: ,run_payact.payroll_action_id run_payact_id
612: FROM pay_action_interlocks archive_intlck
613: ,pay_assignment_actions prepay_assact
614: ,pay_payroll_actions prepay_payact
615: ,pay_action_interlocks prepay_intlck
616: ,pay_assignment_actions run_assact
617: ,pay_payroll_actions run_payact
618: ,pay_assignment_actions archive_assact
619: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 2059: FROM pay_action_interlocks archive_intlck

2055: ,run_assact.assignment_id run_assgt_id
2056: ,run_assact.assignment_action_id run_assact_id
2057: ,run_payact.payroll_action_id run_payact_id
2058: ,run_payact.payroll_id payroll_id
2059: FROM pay_action_interlocks archive_intlck
2060: ,pay_assignment_actions prepay_assact
2061: ,pay_payroll_actions prepay_payact
2062: ,pay_action_interlocks prepay_intlck
2063: ,pay_assignment_actions run_assact

Line 2062: ,pay_action_interlocks prepay_intlck

2058: ,run_payact.payroll_id payroll_id
2059: FROM pay_action_interlocks archive_intlck
2060: ,pay_assignment_actions prepay_assact
2061: ,pay_payroll_actions prepay_payact
2062: ,pay_action_interlocks prepay_intlck
2063: ,pay_assignment_actions run_assact
2064: ,pay_payroll_actions run_payact
2065: WHERE archive_intlck.locking_action_id = p_locking_action_id
2066: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id