DBA Data[Home] [Help]

APPS.OKE_FUNDING_UTIL_PKG dependencies on OKE_FUNDING_PUB

Line 1274: WHERE pm_product_code = OKE_FUNDING_PUB.G_PRODUCT_CODE

1270:
1271: CURSOR c_agreement IS
1272: SELECT agreement_type, customer_id
1273: FROM pa_agreements_all
1274: WHERE pm_product_code = OKE_FUNDING_PUB.G_PRODUCT_CODE
1275: AND pm_agreement_reference LIKE '%-' || to_char(x_funding_source_id);
1276:
1277: begin
1278:

Line 1344: WHERE pm_product_code = OKE_FUNDING_PUB.G_PRODUCT_CODE

1340: l_flag VARCHAR2(1) := 'N';
1341: CURSOR c_agr IS
1342: SELECT 'Y'
1343: FROM pa_agreements_all
1344: WHERE pm_product_code = OKE_FUNDING_PUB.G_PRODUCT_CODE
1345: AND pm_agreement_reference LIKE '%-' || to_char(x_funding_source_id);
1346:
1347: BEGIN
1348: OPEN c_agr;