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

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

Line 463: FROM pay_action_interlocks pai1,

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

Line 473: FROM pay_action_interlocks pai1,

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

Line 583: FROM pay_action_interlocks archive_intlck

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

Line 586: ,pay_action_interlocks prepay_intlck

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

Line 606: FROM pay_action_interlocks archive_intlck

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

Line 609: ,pay_action_interlocks prepay_intlck

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

Line 2333: FROM pay_action_interlocks archive_intlck

2329: ,run_assact.assignment_id run_assgt_id
2330: ,run_assact.assignment_action_id run_assact_id
2331: ,run_payact.payroll_action_id run_payact_id
2332: ,run_payact.payroll_id payroll_id
2333: FROM pay_action_interlocks archive_intlck
2334: ,pay_assignment_actions prepay_assact
2335: ,pay_payroll_actions prepay_payact
2336: ,pay_action_interlocks prepay_intlck
2337: ,pay_assignment_actions run_assact

Line 2336: ,pay_action_interlocks prepay_intlck

2332: ,run_payact.payroll_id payroll_id
2333: FROM pay_action_interlocks archive_intlck
2334: ,pay_assignment_actions prepay_assact
2335: ,pay_payroll_actions prepay_payact
2336: ,pay_action_interlocks prepay_intlck
2337: ,pay_assignment_actions run_assact
2338: ,pay_payroll_actions run_payact
2339: WHERE archive_intlck.locking_action_id = p_locking_action_id
2340: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id