APPS.WSMPVCPD dependencies on WSM_CO_PRODUCTS

Line 29: ** FROM wsm_co_products bcp

25: ** SELECT 'Y'
26: ** INTO x_result
27: ** FROM sys.dual
28: ** WHERE EXISTS (SELECT 1
29: ** FROM wsm_co_products bcp
30: ** WHERE bcp.bill_sequence_id = x_bill_sequence_id
31: ** AND sysdate >= bcp.effectivity_date
32: ** AND (sysdate <= bcp.disable_date
33: ** OR bcp.disable_date is NULL));

Line 51: FROM wsm_co_products bcp

47: -- modification begin for perf. tuning.. abedajna 10/12/00
48:
49: SELECT 'Y'
50: INTO x_result
51: FROM wsm_co_products bcp
52: WHERE bcp.bill_sequence_id = x_bill_sequence_id
53: AND sysdate >= bcp.effectivity_date
54: AND (sysdate <= bcp.disable_date
55: OR bcp.disable_date is NULL);

Line 115: FROM wsm_co_products bcp

111: SELECT 1
112: INTO x_dummy
113: FROM sys.dual
114: WHERE NOT EXISTS (SELECT 1
115: FROM wsm_co_products bcp
116: WHERE bcp.co_product_group_id = x_co_product_group_id
117: AND bcp.co_product_id = x_co_product_id
118: AND ((rowid <> X_Rowid) OR (X_Rowid IS NULL)));
119:

Line 225: ** FROM wsm_co_products bcp

221: ** SELECT 1
222: ** INTO x_dummy
223: ** FROM sys.dual
224: ** WHERE EXISTS (SELECT 1
225: ** FROM wsm_co_products bcp
226: ** WHERE bcp.co_product_group_id = x_co_product_group_id
227: ** AND bcp.co_product_id = x_substitute_co_product_id);
228: **
229: ** EXCEPTION

Line 237: FROM wsm_co_products bcp

233: -- modification begin for perf. tuning.. abedajna 10/12/00
234:
235: SELECT 1
236: INTO x_dummy
237: FROM wsm_co_products bcp
238: WHERE bcp.co_product_group_id = x_co_product_group_id
239: AND bcp.co_product_id = x_substitute_co_product_id;
240:
241: EXCEPTION

Line 368: ** FROM wsm_co_products bcp

364: ** SELECT 1
365: ** INTO x_dummy
366: ** FROM sys.dual
367: ** WHERE EXISTS (SELECT 1
368: ** FROM wsm_co_products bcp
369: ** WHERE bcp.co_product_group_id = x_co_product_group_id
370: ** AND bcp.primary_flag = 'Y'
371: ** AND bcp.co_product_id is not NULL);
372: **

Line 392: FROM wsm_co_products bcp

388: -- modification begin for perf. tuning.. abedajna 10/12/00
389:
390: SELECT 1
391: INTO x_dummy
392: FROM wsm_co_products bcp
393: WHERE bcp.co_product_group_id = x_co_product_group_id
394: AND bcp.primary_flag = 'Y'
395: AND bcp.co_product_id is not NULL;
396:

Line 458: FROM wsm_co_products bcp

454:
455: /* ST : coproducts time phased split enhancement begin */
456: /*SELECT sum (nvl(bcp.split,0))
457: INTO x_split_total
458: FROM wsm_co_products bcp
459: WHERE bcp.co_product_group_id = x_co_product_group_id
460: AND bcp.co_product_id is not NULL; */
461:
462: /* Look into split percentages table to validate */

Line 537: FROM wsm_co_products bcp

533: x_progress := '020';
534:
535: SELECT count(1)
536: INTO x_active_link
537: FROM wsm_co_products bcp
538: WHERE bcp.bill_sequence_id = x_comm_bill_sequence_id
539: AND ( bcp.disable_date is NULL
540: OR bcp.disable_date > sysdate)
541: AND bcp.co_product_group_id <> x_co_product_group_id;

Line 635: FROM wsm_co_products bcp

631: x_dummy := 0;
632:
633: SELECT 1
634: INTO x_dummy
635: FROM wsm_co_products bcp
636: WHERE bcp.organization_id = x_org_id
637: AND bcp.component_id = x_component_id
638: AND (x_disable_date is NULL
639: OR (x_disable_date > bcp.effectivity_date))