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

Line 445: pay_action_interlocks pai,

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

Line 471: FROM pay_action_interlocks pai1,

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

Line 481: FROM pay_action_interlocks pai1,

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

Line 591: FROM pay_action_interlocks archive_intlck

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

Line 594: ,pay_action_interlocks prepay_intlck

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

Line 614: FROM pay_action_interlocks archive_intlck

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

Line 617: ,pay_action_interlocks prepay_intlck

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

Line 2321: FROM pay_action_interlocks archive_intlck

2317: ,run_assact.assignment_id run_assgt_id
2318: ,run_assact.assignment_action_id run_assact_id
2319: ,run_payact.payroll_action_id run_payact_id
2320: ,run_payact.payroll_id payroll_id
2321: FROM pay_action_interlocks archive_intlck
2322: ,pay_assignment_actions prepay_assact
2323: ,pay_payroll_actions prepay_payact
2324: ,pay_action_interlocks prepay_intlck
2325: ,pay_assignment_actions run_assact

Line 2324: ,pay_action_interlocks prepay_intlck

2320: ,run_payact.payroll_id payroll_id
2321: FROM pay_action_interlocks archive_intlck
2322: ,pay_assignment_actions prepay_assact
2323: ,pay_payroll_actions prepay_payact
2324: ,pay_action_interlocks prepay_intlck
2325: ,pay_assignment_actions run_assact
2326: ,pay_payroll_actions run_payact
2327: WHERE archive_intlck.locking_action_id = p_locking_action_id
2328: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id