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

Line 464: pay_action_interlocks pai,

460: pay_payroll_actions appa,
461: pay_payroll_actions appa2,
462: pay_assignment_actions act,
463: pay_assignment_actions act1,
464: pay_action_interlocks pai,
465: per_all_assignments_f as1
466: WHERE ppa.payroll_action_id = p_payroll_action_id
467: AND appa.consolidation_set_id = p_consolidation_id
468: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date

Line 485: FROM pay_action_interlocks pai1,

481: AND appa2.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date
482: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
483:
484: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
485: FROM pay_action_interlocks pai1,
486: pay_assignment_actions act2,
487: pay_payroll_actions appa3
488: WHERE pai1.locked_action_id = act.assignment_action_id
489: AND act2.assignment_action_id= pai1.locking_action_id

Line 496: FROM pay_action_interlocks pai1,

492: AND appa3.action_status = 'C'
493: AND appa3.report_type = 'PYDKARCHIVE')
494:
495: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
496: FROM pay_action_interlocks pai1,
497: pay_assignment_actions act2,
498: pay_payroll_actions appa3
499: WHERE pai1.locked_action_id = act.assignment_action_id
500: AND act2.assignment_action_id= pai1.locking_action_id

Line 603: FROM pay_action_interlocks archive_intlck

599:
600: CURSOR csr_prepay_id IS
601: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
602: ,run_payact.date_earned date_earned
603: FROM pay_action_interlocks archive_intlck
604: ,pay_assignment_actions prepay_assact
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact

Line 606: ,pay_action_interlocks prepay_intlck

602: ,run_payact.date_earned date_earned
603: FROM pay_action_interlocks archive_intlck
604: ,pay_assignment_actions prepay_assact
605: ,pay_payroll_actions prepay_payact
606: ,pay_action_interlocks prepay_intlck
607: ,pay_assignment_actions run_assact
608: ,pay_payroll_actions run_payact
609: ,pay_assignment_actions archive_assact
610: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 628: FROM pay_action_interlocks archive_intlck

624: CURSOR csr_runact_id IS
625: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
626: ,run_payact.date_earned date_earned
627: ,run_payact.payroll_action_id run_payact_id
628: FROM pay_action_interlocks archive_intlck
629: ,pay_assignment_actions prepay_assact
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact

Line 631: ,pay_action_interlocks prepay_intlck

627: ,run_payact.payroll_action_id run_payact_id
628: FROM pay_action_interlocks archive_intlck
629: ,pay_assignment_actions prepay_assact
630: ,pay_payroll_actions prepay_payact
631: ,pay_action_interlocks prepay_intlck
632: ,pay_assignment_actions run_assact
633: ,pay_payroll_actions run_payact
634: ,pay_assignment_actions archive_assact
635: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 2839: FROM pay_action_interlocks archive_intlck

2835: ,run_assact.assignment_id run_assgt_id
2836: ,run_assact.assignment_action_id run_assact_id
2837: ,run_payact.payroll_action_id run_payact_id
2838: ,run_payact.payroll_id payroll_id
2839: FROM pay_action_interlocks archive_intlck
2840: ,pay_assignment_actions prepay_assact
2841: ,pay_payroll_actions prepay_payact
2842: ,pay_action_interlocks prepay_intlck
2843: ,pay_assignment_actions run_assact

Line 2842: ,pay_action_interlocks prepay_intlck

2838: ,run_payact.payroll_id payroll_id
2839: FROM pay_action_interlocks archive_intlck
2840: ,pay_assignment_actions prepay_assact
2841: ,pay_payroll_actions prepay_payact
2842: ,pay_action_interlocks prepay_intlck
2843: ,pay_assignment_actions run_assact
2844: ,pay_payroll_actions run_payact
2845: WHERE archive_intlck.locking_action_id = p_locking_action_id
2846: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id