DBA Data[Home] [Help]

APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_NEGOTIATION_STYLES

Line 5121: OR NOT EXISTS(select 1 from pon_negotiation_styles_vl ds, pon_doctype_styles ts

5117: SYSDATE,
5118: l_cp_login_id
5119: )
5120: WHEN (l_style_id IS NULL
5121: OR NOT EXISTS(select 1 from pon_negotiation_styles_vl ds, pon_doctype_styles ts
5122: WHERE ds.style_id = l_style_id
5123: AND ds.style_id = ts.style_id
5124: and ds.status = 'ACTIVE'
5125: and ts.doctype_id = l_doctype_id

Line 6809: PON_NEGOTIATION_STYLES WHERE STYLE_ID = neg_header_record_data.style_id;

6805: neg_header_record_data.INTGR_CAT_LINE_ATTR_FLAG,
6806: neg_header_record_data.INTGR_ITEM_LINE_ATTR_FLAG,
6807: neg_header_record_data.INTGR_CAT_LINE_ASL_FLAG
6808: FROM
6809: PON_NEGOTIATION_STYLES WHERE STYLE_ID = neg_header_record_data.style_id;
6810:
6811: IF ( neg_header_record_data.QTY_PRICE_TIERS_ENABLED_FLAG = 'N' ) THEN
6812: neg_header_record_data.price_tiers_indicator := NULL;
6813: END IF;