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 457: pay_action_interlocks pai,

453: pay_payroll_actions appa,
454: pay_payroll_actions appa2,
455: pay_assignment_actions act,
456: pay_assignment_actions act1,
457: pay_action_interlocks pai,
458: per_all_assignments_f as1
459: WHERE ppa.payroll_action_id = p_payroll_action_id
460: AND appa.consolidation_set_id = p_consolidation_id
461: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date

Line 478: FROM pay_action_interlocks pai1,

474: AND appa2.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date
475: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
476:
477: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
478: FROM pay_action_interlocks pai1,
479: pay_assignment_actions act2,
480: pay_payroll_actions appa3
481: WHERE pai1.locked_action_id = act.assignment_action_id
482: AND act2.assignment_action_id= pai1.locking_action_id

Line 489: FROM pay_action_interlocks pai1,

485: AND appa3.action_status = 'C'
486: AND appa3.report_type = 'PYDKARCHIVE')
487:
488: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
489: FROM pay_action_interlocks pai1,
490: pay_assignment_actions act2,
491: pay_payroll_actions appa3
492: WHERE pai1.locked_action_id = act.assignment_action_id
493: AND act2.assignment_action_id= pai1.locking_action_id

Line 596: FROM pay_action_interlocks archive_intlck

592:
593: CURSOR csr_prepay_id IS
594: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
595: ,run_payact.date_earned date_earned
596: FROM pay_action_interlocks archive_intlck
597: ,pay_assignment_actions prepay_assact
598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact

Line 599: ,pay_action_interlocks prepay_intlck

595: ,run_payact.date_earned date_earned
596: FROM pay_action_interlocks archive_intlck
597: ,pay_assignment_actions prepay_assact
598: ,pay_payroll_actions prepay_payact
599: ,pay_action_interlocks prepay_intlck
600: ,pay_assignment_actions run_assact
601: ,pay_payroll_actions run_payact
602: ,pay_assignment_actions archive_assact
603: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 621: FROM pay_action_interlocks archive_intlck

617: CURSOR csr_runact_id IS
618: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
619: ,run_payact.date_earned date_earned
620: ,run_payact.payroll_action_id run_payact_id
621: FROM pay_action_interlocks archive_intlck
622: ,pay_assignment_actions prepay_assact
623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact

Line 624: ,pay_action_interlocks prepay_intlck

620: ,run_payact.payroll_action_id run_payact_id
621: FROM pay_action_interlocks archive_intlck
622: ,pay_assignment_actions prepay_assact
623: ,pay_payroll_actions prepay_payact
624: ,pay_action_interlocks prepay_intlck
625: ,pay_assignment_actions run_assact
626: ,pay_payroll_actions run_payact
627: ,pay_assignment_actions archive_assact
628: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 2397: FROM pay_action_interlocks archive_intlck

2393: ,run_assact.assignment_id run_assgt_id
2394: ,run_assact.assignment_action_id run_assact_id
2395: ,run_payact.payroll_action_id run_payact_id
2396: ,run_payact.payroll_id payroll_id
2397: FROM pay_action_interlocks archive_intlck
2398: ,pay_assignment_actions prepay_assact
2399: ,pay_payroll_actions prepay_payact
2400: ,pay_action_interlocks prepay_intlck
2401: ,pay_assignment_actions run_assact

Line 2400: ,pay_action_interlocks prepay_intlck

2396: ,run_payact.payroll_id payroll_id
2397: FROM pay_action_interlocks archive_intlck
2398: ,pay_assignment_actions prepay_assact
2399: ,pay_payroll_actions prepay_payact
2400: ,pay_action_interlocks prepay_intlck
2401: ,pay_assignment_actions run_assact
2402: ,pay_payroll_actions run_payact
2403: WHERE archive_intlck.locking_action_id = p_locking_action_id
2404: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id