DBA Data[Home] [Help]

APPS.OKL_CS_TRANSACTIONS_PVT dependencies on MO_GLOBAL

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

130: fnd.description svf_desc
131: FROM fnd_lookups fnd,
132: okl_service_fees_b svf
133: WHERE svf.srv_code = p_svf_code
134: AND NVL(svf.organization_id, -99) = NVL(mo_global.get_current_org_id(), -99)
135: AND svf.srv_code = fnd.lookup_code
136: AND lookup_type = 'OKL_SERVICE_FEES';
137:
138: i BINARY_INTEGER := 0;

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

426: x_msg_data OUT NOCOPY VARCHAR2) IS
427:
428: CURSOR c_ptm IS SELECT 1
429: FROM okl_process_tmplts_b
430: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
431: AND ptm_code = p_ptm_code
432: AND start_date <= TRUNC(SYSDATE)
433: AND NVL(end_date, TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
434: