839: p_disbursement_basis IN VARCHAR2) IS
840:
841: CURSOR l_disbursement_basis_csr (p_disbursement_basis in varchar2) IS
842: SELECT 'Y'
843: From FND_LOOKUPS
844: Where lookup_type = 'OKL_DISBURSE_BASIS'
845: And nvl(enabled_flag,'N') = 'Y'
846: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
847: And lookup_code = p_disbursement_basis;
892: p_processing_fee_basis IN VARCHAR2) IS
893:
894: CURSOR l_processing_fee_basis_csr (p_processing_fee_basis in varchar2) IS
895: SELECT 'Y'
896: From FND_LOOKUPS
897: Where lookup_type = 'OKL_PROC_FEE_BASIS'
898: And nvl(enabled_flag,'N') = 'Y'
899: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
900: And lookup_code = p_processing_fee_basis;
945: p_payment_basis IN VARCHAR2) IS
946:
947: CURSOR l_payment_basis_csr (p_payment_basis in varchar2) IS
948: SELECT 'Y'
949: From FND_LOOKUPS
950: Where lookup_type = 'OKL_PAYMENT_BASIS'
951: And nvl(enabled_flag,'N') = 'Y'
952: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
953: And lookup_code = p_payment_basis;
998: p_payment_frequency IN VARCHAR2) IS
999:
1000: CURSOR l_payment_frequency_csr (p_payment_frequency in varchar2) IS
1001: SELECT 'Y'
1002: From FND_LOOKUPS
1003: Where lookup_type = 'OKL_PAYMENT_FRQ'
1004: And nvl(enabled_flag,'N') = 'Y'
1005: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
1006: And lookup_code = p_payment_frequency;