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_GB_P11D_ARCHIVE_SS dependencies on PAY_PAYROLLS_F

Line 149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org

145: IS
146: SELECT org.org_information1 employers_ref_no, org.org_information2 tax_office_name,
147: org.org_information8 tax_office_phone_no, org.org_information3 employer_name,
148: org.org_information4 employer_address
149: FROM pay_payrolls_f ppf, hr_soft_coding_keyflex flex, hr_organization_information org
150: WHERE ppf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
151: AND fnd_date.canonical_to_date(v_benefit_end_date)
152: BETWEEN NVL(flex.start_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )
153: AND NVL(flex.end_date_active, fnd_date.canonical_to_date(v_benefit_end_date) )

Line 686: ppf PAY_PAYROLLS_F_PK)

682: order by paa.assignment_id;
683:
684: cursor csr_noassign_set is
685: select /*+ ORDERED INDEX(paa PER_ASSIGNMENTS_F_N12,
686: ppf PAY_PAYROLLS_F_PK)
687: USE_NL(paa,ppf,pec,pet,piv,pee,peev) */
688: distinct
689: paa.assignment_id,
690: paa.person_id,