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

Line 871: pay_action_interlocks pai,

867: pay_payroll_actions appa,
868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,
871: pay_action_interlocks pai,
872: per_all_assignments_f as1
873: WHERE ppa.payroll_action_id = p_payroll_action_id
874: AND appa.consolidation_set_id = p_consolidation_id
875: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date

Line 892: FROM pay_action_interlocks pai1,

888: AND appa2.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date
889: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
890:
891: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
892: FROM pay_action_interlocks pai1,
893: pay_assignment_actions act2,
894: pay_payroll_actions appa3
895: WHERE pai1.locked_action_id = act.assignment_action_id
896: AND act2.assignment_action_id= pai1.locking_action_id

Line 903: FROM pay_action_interlocks pai1,

899: AND appa3.action_status = 'C'
900: AND appa3.report_type = 'PYNOARCHIVE')
901:
902: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
903: FROM pay_action_interlocks pai1,
904: pay_assignment_actions act2,
905: pay_payroll_actions appa3
906: WHERE pai1.locked_action_id = act.assignment_action_id
907: AND act2.assignment_action_id= pai1.locking_action_id

Line 1010: FROM pay_action_interlocks archive_intlck

1006:
1007: CURSOR csr_prepay_id IS
1008: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
1009: ,run_payact.date_earned date_earned
1010: FROM pay_action_interlocks archive_intlck
1011: ,pay_assignment_actions prepay_assact
1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact

Line 1013: ,pay_action_interlocks prepay_intlck

1009: ,run_payact.date_earned date_earned
1010: FROM pay_action_interlocks archive_intlck
1011: ,pay_assignment_actions prepay_assact
1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact
1015: ,pay_payroll_actions run_payact
1016: ,pay_assignment_actions archive_assact
1017: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 1035: FROM pay_action_interlocks archive_intlck

1031: CURSOR csr_runact_id IS
1032: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
1033: ,run_payact.date_earned date_earned
1034: ,run_payact.payroll_action_id run_payact_id
1035: FROM pay_action_interlocks archive_intlck
1036: ,pay_assignment_actions prepay_assact
1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact

Line 1038: ,pay_action_interlocks prepay_intlck

1034: ,run_payact.payroll_action_id run_payact_id
1035: FROM pay_action_interlocks archive_intlck
1036: ,pay_assignment_actions prepay_assact
1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact
1040: ,pay_payroll_actions run_payact
1041: ,pay_assignment_actions archive_assact
1042: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id

Line 3554: FROM pay_action_interlocks archive_intlck

3550: ,run_assact.assignment_id run_assgt_id
3551: ,run_assact.assignment_action_id run_assact_id
3552: ,run_payact.payroll_action_id run_payact_id
3553: ,run_payact.payroll_id payroll_id
3554: FROM pay_action_interlocks archive_intlck
3555: ,pay_assignment_actions prepay_assact
3556: ,pay_payroll_actions prepay_payact
3557: ,pay_action_interlocks prepay_intlck
3558: ,pay_assignment_actions run_assact

Line 3557: ,pay_action_interlocks prepay_intlck

3553: ,run_payact.payroll_id payroll_id
3554: FROM pay_action_interlocks archive_intlck
3555: ,pay_assignment_actions prepay_assact
3556: ,pay_payroll_actions prepay_payact
3557: ,pay_action_interlocks prepay_intlck
3558: ,pay_assignment_actions run_assact
3559: ,pay_payroll_actions run_payact
3560: WHERE archive_intlck.locking_action_id = p_locking_action_id
3561: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 3581: FROM pay_action_interlocks archive_intlck

3577: ,run_assact.assignment_id run_assgt_id
3578: ,run_assact.assignment_action_id run_assact_id
3579: ,run_payact.payroll_action_id run_payact_id
3580: ,run_payact.payroll_id payroll_id
3581: FROM pay_action_interlocks archive_intlck
3582: ,pay_assignment_actions prepay_assact
3583: ,pay_payroll_actions prepay_payact
3584: ,pay_action_interlocks prepay_intlck
3585: ,pay_assignment_actions run_assact

Line 3584: ,pay_action_interlocks prepay_intlck

3580: ,run_payact.payroll_id payroll_id
3581: FROM pay_action_interlocks archive_intlck
3582: ,pay_assignment_actions prepay_assact
3583: ,pay_payroll_actions prepay_payact
3584: ,pay_action_interlocks prepay_intlck
3585: ,pay_assignment_actions run_assact
3586: ,pay_payroll_actions run_payact
3587: WHERE archive_intlck.locking_action_id = p_locking_action_id
3588: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id