DBA Data[Home] [Help]

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 3807: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;

3803: from PO_VENDOR_SITES_ALL a
3804: where vendor_site_id = p_vendor_site_id
3805: ;
3806:
3807: -- select apps.FND_DOC_SEQ_885_S.nextval from dual;
3808:
3809: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';--'OKL Lease Receipt Invoices';
3810: l_okl_application_id number(3) := 540;
3811:

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

6716: --SELECT cle_id, KLE_AMT
6717: --FROM
6718: --(
6719: select a.cle_id,
6720: (select OKL_FUNDING_PVT.get_contract_line_amt(a.CHR_ID, a.CLE_ID, b.ipvs_id) from dual) KLE_AMT
6721: from OKL_ASSETS_LOV_UV A,
6722: OKL_TRX_AP_INVOICES_B b
6723: WHERE a.chr_id = b.khr_id
6724: AND b.ID = p_fund_id