APPS.OKL_FUNDING_PVT dependencies on DUAL

Line 1304: -- from dual;

1300:
1301:
1302:
1303: --select mo_global.get_current_org_id() into l_fnd_profile
1304: -- from dual;
1305:
1306:
1307: --JTF_RS_SALESREPS_MO_V
1308:

Line 3677: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;

3673: from PO_VENDOR_SITES_ALL a
3674: where vendor_site_id = p_vendor_site_id
3675: ;
3676:
3677: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;
3678:
3679: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';--'OKL Lease Receipt Invoices';
3680: l_okl_application_id number(3) := 540;
3681:

Line 6563: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT

6559: --SELECT cle_id, KLE_AMT
6560: --FROM
6561: --(
6562: select a.cle_id,
6563: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT
6564: from OKL_ASSETS_LOV_UV A,
6565: OKL_TRX_AP_INVOICES_B b
6566: WHERE a.chr_id = b.khr_id
6567: AND b.ID = p_fund_id