APPS.OKL_PYD_PVT dependencies on FND_LOOKUPS

Line 833: From FND_LOOKUPS

829: p_disbursement_basis IN VARCHAR2) IS
830:
831: CURSOR l_disbursement_basis_csr (p_disbursement_basis in varchar2) IS
832: SELECT 'Y'
833: From FND_LOOKUPS
834: Where lookup_type = 'OKL_DISBURSE_BASIS'
835: And nvl(enabled_flag,'N') = 'Y'
836: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
837: And lookup_code = p_disbursement_basis;

Line 886: From FND_LOOKUPS

882: p_processing_fee_basis IN VARCHAR2) IS
883:
884: CURSOR l_processing_fee_basis_csr (p_processing_fee_basis in varchar2) IS
885: SELECT 'Y'
886: From FND_LOOKUPS
887: Where lookup_type = 'OKL_PROC_FEE_BASIS'
888: And nvl(enabled_flag,'N') = 'Y'
889: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
890: And lookup_code = p_processing_fee_basis;

Line 939: From FND_LOOKUPS

935: p_payment_basis IN VARCHAR2) IS
936:
937: CURSOR l_payment_basis_csr (p_payment_basis in varchar2) IS
938: SELECT 'Y'
939: From FND_LOOKUPS
940: Where lookup_type = 'OKL_PAYMENT_BASIS'
941: And nvl(enabled_flag,'N') = 'Y'
942: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
943: And lookup_code = p_payment_basis;

Line 992: From FND_LOOKUPS

988: p_payment_frequency IN VARCHAR2) IS
989:
990: CURSOR l_payment_frequency_csr (p_payment_frequency in varchar2) IS
991: SELECT 'Y'
992: From FND_LOOKUPS
993: Where lookup_type = 'OKL_PAYMENT_FRQ'
994: And nvl(enabled_flag,'N') = 'Y'
995: And sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate)
996: And lookup_code = p_payment_frequency;