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

Line 370: pay_action_interlocks pai,

366: pay_payroll_actions appa,
367: pay_payroll_actions appa2,
368: pay_assignment_actions act,
369: pay_assignment_actions act1,
370: pay_action_interlocks pai,
371: per_all_assignments_f as1
372: WHERE ppa.payroll_action_id = p_payroll_action_id
373: AND appa.consolidation_set_id = p_consolidation_id
374: AND appa.effective_date BETWEEN l_canonical_start_date

Line 396: FROM pay_action_interlocks pai1,

392: AND l_canonical_end_date
393: -- Prepayments or Quickpay Prepayments
394: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
395: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
396: FROM pay_action_interlocks pai1,
397: pay_assignment_actions act2,
398: pay_payroll_actions appa3
399: WHERE pai1.locked_action_id = act.assignment_action_id
400: AND act2.assignment_action_id= pai1.locking_action_id

Line 406: FROM pay_action_interlocks pai1,

402: AND appa3.action_type = 'X'
403: AND appa3.action_status = 'C'
404: AND appa3.report_type = 'FI_ARCHIVE')
405: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
406: FROM pay_action_interlocks pai1,
407: pay_assignment_actions act2,
408: pay_payroll_actions appa3
409: WHERE pai1.locked_action_id = act.assignment_action_id
410: AND act2.assignment_action_id= pai1.locking_action_id

Line 487: FROM pay_action_interlocks archive_intlck

483: IS
484: CURSOR csr_prepay_id IS
485: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
486: ,run_payact.date_earned date_earned
487: FROM pay_action_interlocks archive_intlck
488: ,pay_assignment_actions prepay_assact
489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact

Line 490: ,pay_action_interlocks prepay_intlck

486: ,run_payact.date_earned date_earned
487: FROM pay_action_interlocks archive_intlck
488: ,pay_assignment_actions prepay_assact
489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact
492: ,pay_payroll_actions run_payact
493: ,pay_assignment_actions archive_assact
494: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 509: FROM pay_action_interlocks archive_intlck

505: CURSOR csr_runact_id IS
506: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
507: ,run_payact.date_earned date_earned
508: ,run_payact.payroll_action_id run_payact_id
509: FROM pay_action_interlocks archive_intlck
510: ,pay_assignment_actions prepay_assact
511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact

Line 512: ,pay_action_interlocks prepay_intlck

508: ,run_payact.payroll_action_id run_payact_id
509: FROM pay_action_interlocks archive_intlck
510: ,pay_assignment_actions prepay_assact
511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact
514: ,pay_payroll_actions run_payact
515: ,pay_assignment_actions archive_assact
516: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 2539: FROM pay_action_interlocks archive_intlck

2535: ,run_assact.assignment_id run_assgt_id
2536: ,run_assact.assignment_action_id run_assact_id
2537: ,run_payact.payroll_action_id run_payact_id
2538: ,run_payact.payroll_id payroll_id
2539: FROM pay_action_interlocks archive_intlck
2540: ,pay_assignment_actions prepay_assact
2541: ,pay_payroll_actions prepay_payact
2542: ,pay_action_interlocks prepay_intlck
2543: ,pay_assignment_actions run_assact

Line 2542: ,pay_action_interlocks prepay_intlck

2538: ,run_payact.payroll_id payroll_id
2539: FROM pay_action_interlocks archive_intlck
2540: ,pay_assignment_actions prepay_assact
2541: ,pay_payroll_actions prepay_payact
2542: ,pay_action_interlocks prepay_intlck
2543: ,pay_assignment_actions run_assact
2544: ,pay_payroll_actions run_payact
2545: WHERE archive_intlck.locking_action_id = p_locking_action_id
2546: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id