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.OKL_OPEN_INTERFACE_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 19420: CURSOR pmnt_basis_csr (p_payment_basis OKL_PARTY_PAYMENT_DTLS.payment_basis%TYPE) IS

19416: p_customer_id IS NOT NULL
19417: )
19418: );
19419:
19420: CURSOR pmnt_basis_csr (p_payment_basis OKL_PARTY_PAYMENT_DTLS.payment_basis%TYPE) IS
19421: SELECT 'Y'
19422: FROM FND_LOOKUPS
19423: WHERE lookup_type = 'OKL_PAYMENT_BASIS'
19424: AND nvl(enabled_flag,'N') = 'Y'

Line 19428: CURSOR disb_basis_csr (p_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS

19424: AND nvl(enabled_flag,'N') = 'Y'
19425: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19426: AND lookup_code = p_payment_basis;
19427:
19428: CURSOR disb_basis_csr (p_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19429: SELECT 'Y'
19430: FROM FND_LOOKUPS
19431: WHERE lookup_type = 'OKL_DISBURSE_BASIS'
19432: AND nvl(enabled_flag,'N') = 'Y'

Line 19436: CURSOR proc_fee_basis_csr (p_processing_fee_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS

19432: AND nvl(enabled_flag,'N') = 'Y'
19433: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19434: AND lookup_code = p_disbursement_basis;
19435:
19436: CURSOR proc_fee_basis_csr (p_processing_fee_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19437: SELECT 'Y'
19438: FROM FND_LOOKUPS
19439: WHERE lookup_type = 'OKL_PROC_FEE_BASIS'
19440: AND nvl(enabled_flag,'N') = 'Y'