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 PAY_PAYROLLS_F

Line 620: FROM pay_payrolls_f ppf,

616: SELECT pact.payroll_action_id payroll_action_id
617: ,pact.effective_date effective_date
618: ,pact.date_earned date_earned
619: ,pact.pay_advice_message payroll_message
620: FROM pay_payrolls_f ppf,
621: pay_payroll_actions pact
622: WHERE pact.payroll_id = ppf.payroll_id
623: AND pact.effective_date BETWEEN ppf.effective_start_date
624: AND ppf.effective_end_date

Line 834: INDEX(ppf PAY_PAYROLLS_F_PK)

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)
838: INDEX(act1 PAY_ASSIGNMENT_ACTIONS_PK)

Line 851: pay_payrolls_f ppf

847: pay_payroll_actions appa,
848: pay_action_interlocks pai,
849: pay_assignment_actions act1,
850: pay_payroll_actions appa2,
851: pay_payrolls_f ppf
852: WHERE ppa.payroll_action_id = p_pact_id
853: AND appa.consolidation_set_id = p_consolidation_id
854: AND appa.effective_date BETWEEN l_canonical_start_date AND l_canonical_end_date
855: AND as1.person_id BETWEEN stperson AND endperson