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

Line 400: pay_action_interlocks pai,

396: pay_payroll_actions appa,
397: pay_payroll_actions appa2,
398: pay_assignment_actions act,
399: pay_assignment_actions act1,
400: pay_action_interlocks pai,
401: per_all_assignments_f as1
402: WHERE ppa.payroll_action_id = p_payroll_action_id
403: AND appa.consolidation_set_id = p_consolidation_id
404: AND appa.effective_date BETWEEN l_canonical_start_date

Line 426: FROM pay_action_interlocks pai1,

422: AND l_canonical_end_date
423: -- Prepayments or Quickpay Prepayments
424: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
425: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
426: FROM pay_action_interlocks pai1,
427: pay_assignment_actions act2,
428: pay_payroll_actions appa3
429: WHERE pai1.locked_action_id = act.assignment_action_id
430: AND act2.assignment_action_id= pai1.locking_action_id

Line 436: FROM pay_action_interlocks pai1,

432: AND appa3.action_type = 'X'
433: AND appa3.action_status = 'C'
434: AND appa3.report_type = 'SE_ARCHIVE')
435: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
436: FROM pay_action_interlocks pai1,
437: pay_assignment_actions act2,
438: pay_payroll_actions appa3
439: WHERE pai1.locked_action_id = act.assignment_action_id
440: AND act2.assignment_action_id= pai1.locking_action_id

Line 521: FROM pay_action_interlocks archive_intlck

517: IS
518: CURSOR csr_prepay_id IS
519: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
520: ,run_payact.date_earned date_earned
521: FROM pay_action_interlocks archive_intlck
522: ,pay_assignment_actions prepay_assact
523: ,pay_payroll_actions prepay_payact
524: ,pay_action_interlocks prepay_intlck
525: ,pay_assignment_actions run_assact

Line 524: ,pay_action_interlocks prepay_intlck

520: ,run_payact.date_earned date_earned
521: FROM pay_action_interlocks archive_intlck
522: ,pay_assignment_actions prepay_assact
523: ,pay_payroll_actions prepay_payact
524: ,pay_action_interlocks prepay_intlck
525: ,pay_assignment_actions run_assact
526: ,pay_payroll_actions run_payact
527: ,pay_assignment_actions archive_assact
528: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 543: FROM pay_action_interlocks archive_intlck

539: CURSOR csr_runact_id IS
540: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
541: ,run_payact.date_earned date_earned
542: ,run_payact.payroll_action_id run_payact_id
543: FROM pay_action_interlocks archive_intlck
544: ,pay_assignment_actions prepay_assact
545: ,pay_payroll_actions prepay_payact
546: ,pay_action_interlocks prepay_intlck
547: ,pay_assignment_actions run_assact

Line 546: ,pay_action_interlocks prepay_intlck

542: ,run_payact.payroll_action_id run_payact_id
543: FROM pay_action_interlocks archive_intlck
544: ,pay_assignment_actions prepay_assact
545: ,pay_payroll_actions prepay_payact
546: ,pay_action_interlocks prepay_intlck
547: ,pay_assignment_actions run_assact
548: ,pay_payroll_actions run_payact
549: ,pay_assignment_actions archive_assact
550: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 2573: FROM pay_action_interlocks archive_intlck

2569: ,run_assact.assignment_id run_assgt_id
2570: ,run_assact.assignment_action_id run_assact_id
2571: ,run_payact.payroll_action_id run_payact_id
2572: ,run_payact.payroll_id payroll_id
2573: FROM pay_action_interlocks archive_intlck
2574: ,pay_assignment_actions prepay_assact
2575: ,pay_payroll_actions prepay_payact
2576: ,pay_action_interlocks prepay_intlck
2577: ,pay_assignment_actions run_assact

Line 2576: ,pay_action_interlocks prepay_intlck

2572: ,run_payact.payroll_id payroll_id
2573: FROM pay_action_interlocks archive_intlck
2574: ,pay_assignment_actions prepay_assact
2575: ,pay_payroll_actions prepay_payact
2576: ,pay_action_interlocks prepay_intlck
2577: ,pay_assignment_actions run_assact
2578: ,pay_payroll_actions run_payact
2579: WHERE archive_intlck.locking_action_id = p_locking_action_id
2580: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id