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_NL_PAYSLIP_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 833: INDEX(as1 PER_ASSIGNMENTS_F_N12)

829: l_canonical_end_date DATE) IS
830: -- Andy's changes for bug 5107780
831: SELECT /*+ ORDERED
832: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
833: INDEX(as1 PER_ASSIGNMENTS_F_N12)
834: INDEX(ppf PAY_PAYROLLS_F_PK)
835: INDEX(act PAY_ASSIGNMENT_ACTIONS_N51)
836: INDEX(appa PAY_PAYROLL_ACTIONS_PK)
837: INDEX(pai PAY_ACTION_INTERLOCKS_FK2)

Line 1485: FROM per_assignments_f paf

1481: ,scl.segment4 tax_reduction
1482: ,scl.segment7 labour_tax_reduction
1483: ,scl.segment9 add_senior_tax_reduction
1484: ,FND_NUMBER.Canonical_To_Number(scl.segment28) individual_working_hours
1485: FROM per_assignments_f paf
1486: ,hr_soft_coding_keyflex scl
1487: WHERE paf.assignment_id = p_assignment_id
1488: AND p_date_earned BETWEEN paf.effective_start_date
1489: AND paf.effective_end_date