DBA Data[Home] [Help]

APPS.QP_MODIFIER_UPGRADE_PVT dependencies on SO_DISCOUNT_CUSTOMERS

Line 272: FROM SO_DISCOUNT_CUSTOMERS

268: CURSOR get_discount_customers(p_discount_id NUMBER) IS
269: SELECT CUSTOMER_CLASS_CODE ,CUSTOMER_ID , SITE_USE_ID,START_DATE_ACTIVE,END_DATE_ACTIVE,CONTEXT,ATTRIBUTE1,
270: ATTRIBUTE2,ATTRIBUTE3, ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,
271: ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15
272: FROM SO_DISCOUNT_CUSTOMERS
273: WHERE DISCOUNT_ID = p_discount_id;
274:
275: CURSOR get_discount_lines(p_discount_id NUMBER) IS
276: SELECT DISCOUNT_LINE_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 653: -- Check other qualifiers from so_discount_customers like customer_class_code,site_use_id,

649: 'DISCOUNTS',
650: x_qualifier_grouping_no);
651: END IF;
652:
653: -- Check other qualifiers from so_discount_customers like customer_class_code,site_use_id,
654: -- customer_id create qualifiers
655: -- There needs to be different group no for each record in so_discount_customers
656:
657: FOR l IN get_discount_customers(i.discount_id)

Line 655: -- There needs to be different group no for each record in so_discount_customers

651: END IF;
652:
653: -- Check other qualifiers from so_discount_customers like customer_class_code,site_use_id,
654: -- customer_id create qualifiers
655: -- There needs to be different group no for each record in so_discount_customers
656:
657: FOR l IN get_discount_customers(i.discount_id)
658: LOOP
659: