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 19238: CURSOR pmnt_basis_csr (p_payment_basis OKL_PARTY_PAYMENT_DTLS.payment_basis%TYPE) IS

19234: p_customer_id IS NOT NULL
19235: )
19236: );
19237:
19238: CURSOR pmnt_basis_csr (p_payment_basis OKL_PARTY_PAYMENT_DTLS.payment_basis%TYPE) IS
19239: SELECT 'Y'
19240: FROM FND_LOOKUPS
19241: WHERE lookup_type = 'OKL_PAYMENT_BASIS'
19242: AND nvl(enabled_flag,'N') = 'Y'

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

19242: AND nvl(enabled_flag,'N') = 'Y'
19243: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19244: AND lookup_code = p_payment_basis;
19245:
19246: CURSOR disb_basis_csr (p_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19247: SELECT 'Y'
19248: FROM FND_LOOKUPS
19249: WHERE lookup_type = 'OKL_DISBURSE_BASIS'
19250: AND nvl(enabled_flag,'N') = 'Y'

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

19250: AND nvl(enabled_flag,'N') = 'Y'
19251: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
19252: AND lookup_code = p_disbursement_basis;
19253:
19254: CURSOR proc_fee_basis_csr (p_processing_fee_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE) IS
19255: SELECT 'Y'
19256: FROM FND_LOOKUPS
19257: WHERE lookup_type = 'OKL_PROC_FEE_BASIS'
19258: AND nvl(enabled_flag,'N') = 'Y'