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

Line 436: pay_action_interlocks pai,

432: pay_payroll_actions appa,
433: pay_payroll_actions appa2,
434: pay_assignment_actions act,
435: pay_assignment_actions act1,
436: pay_action_interlocks pai,
437: per_all_assignments_f as1
438: WHERE ppa.payroll_action_id = p_payroll_action_id
439: AND appa.consolidation_set_id = p_consolidation_id
440: AND appa.effective_date BETWEEN l_canonical_start_date

Line 462: FROM pay_action_interlocks pai1,

458: AND l_canonical_end_date
459: -- Prepayments or Quickpay Prepayments
460: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
461: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
462: FROM pay_action_interlocks pai1,
463: pay_assignment_actions act2,
464: pay_payroll_actions appa3
465: WHERE pai1.locked_action_id = act.assignment_action_id
466: AND act2.assignment_action_id= pai1.locking_action_id

Line 472: FROM pay_action_interlocks pai1,

468: AND appa3.action_type = 'X'
469: AND appa3.action_status = 'C'
470: AND appa3.report_type = 'SA_ARCHIVE')
471: AND NOT EXISTS ( SELECT /*+ ORDERED */ NULL
472: FROM pay_action_interlocks pai1,
473: pay_assignment_actions act2,
474: pay_payroll_actions appa3
475: WHERE pai1.locked_action_id = act.assignment_action_id
476: AND act2.assignment_action_id= pai1.locking_action_id

Line 582: FROM pay_action_interlocks archive_intlck

578:
579: CURSOR csr_prepay_id IS
580: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
581: ,run_payact.date_earned date_earned
582: FROM pay_action_interlocks archive_intlck
583: ,pay_assignment_actions prepay_assact
584: ,pay_payroll_actions prepay_payact
585: ,pay_action_interlocks prepay_intlck
586: ,pay_assignment_actions run_assact

Line 585: ,pay_action_interlocks prepay_intlck

581: ,run_payact.date_earned date_earned
582: FROM pay_action_interlocks archive_intlck
583: ,pay_assignment_actions prepay_assact
584: ,pay_payroll_actions prepay_payact
585: ,pay_action_interlocks prepay_intlck
586: ,pay_assignment_actions run_assact
587: ,pay_payroll_actions run_payact
588: ,pay_assignment_actions archive_assact
589: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 605: FROM pay_action_interlocks archive_intlck

601: CURSOR csr_runact_id IS
602: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
603: ,run_payact.date_earned date_earned
604: ,run_payact.payroll_action_id run_payact_id
605: FROM pay_action_interlocks archive_intlck
606: ,pay_assignment_actions prepay_assact
607: ,pay_payroll_actions prepay_payact
608: ,pay_action_interlocks prepay_intlck
609: ,pay_assignment_actions run_assact

Line 608: ,pay_action_interlocks prepay_intlck

604: ,run_payact.payroll_action_id run_payact_id
605: FROM pay_action_interlocks archive_intlck
606: ,pay_assignment_actions prepay_assact
607: ,pay_payroll_actions prepay_payact
608: ,pay_action_interlocks prepay_intlck
609: ,pay_assignment_actions run_assact
610: ,pay_payroll_actions run_payact
611: ,pay_assignment_actions archive_assact
612: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 2225: FROM pay_action_interlocks archive_intlck

2221: ,run_assact.assignment_id run_assgt_id
2222: ,run_assact.assignment_action_id run_assact_id
2223: ,run_payact.payroll_action_id run_payact_id
2224: ,run_payact.payroll_id payroll_id
2225: FROM pay_action_interlocks archive_intlck
2226: ,pay_assignment_actions prepay_assact
2227: ,pay_payroll_actions prepay_payact
2228: ,pay_action_interlocks prepay_intlck
2229: ,pay_assignment_actions run_assact

Line 2228: ,pay_action_interlocks prepay_intlck

2224: ,run_payact.payroll_id payroll_id
2225: FROM pay_action_interlocks archive_intlck
2226: ,pay_assignment_actions prepay_assact
2227: ,pay_payroll_actions prepay_payact
2228: ,pay_action_interlocks prepay_intlck
2229: ,pay_assignment_actions run_assact
2230: ,pay_payroll_actions run_payact
2231: WHERE archive_intlck.locking_action_id = p_locking_action_id
2232: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id