DBA Data[Home] [Help]

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on MO_GLOBAL

Line 124: AND NVL(svf.organization_id, -99) = NVL(mo_global.get_current_org_id(), -99)

120: fnd.description svf_desc
121: FROM fnd_lookups fnd,
122: okl_service_fees_b svf
123: WHERE svf.srv_code = p_svf_code
124: AND NVL(svf.organization_id, -99) = NVL(mo_global.get_current_org_id(), -99)
125: AND svf.srv_code = fnd.lookup_code
126: AND lookup_type = 'OKL_SERVICE_FEES';
127:
128: i BINARY_INTEGER := 0;

Line 420: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)

416: x_msg_data OUT NOCOPY VARCHAR2) IS
417:
418: CURSOR c_ptm IS SELECT 1
419: FROM okl_process_tmplts_b
420: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
421: AND ptm_code = p_ptm_code
422: AND start_date <= TRUNC(SYSDATE)
423: AND NVL(end_date, TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
424: