APPS.PO_VAL_PRICE_DIFFS2 dependencies on DUAL

Line 68: FROM DUAL

64: 'PRICE_TYPE',
65: p_price_type_tbl(i),
66: DECODE(p_price_type_tbl(i), NULL, PO_VAL_CONSTANTS.c_price_type_not_null,
67: PO_VAL_CONSTANTS.c_price_type_valid)
68: FROM DUAL
69: WHERE p_price_type_tbl(i) IS NULL
70: OR(p_price_type_tbl(i) IS NOT NULL AND
71: NOT EXISTS(SELECT 1
72: FROM po_price_diff_lookups_v

Line 135: FROM DUAL;

131: p_id_tbl(i),
132: p_entity_id_tbl(i),
133: p_entity_type_tbl(i),
134: p_price_type_tbl(i)
135: FROM DUAL;
136:
137: -- Check that we are not creating multiple price differential
138: -- records of the same type for a line/price break record against
139: -- txn table or draft table or records within the same group

Line 162: FROM DUAL

158: p_price_type_tbl(i),
159: NULL,
160: NULL,
161: PO_VAL_CONSTANTS.c_multiple_price_diff
162: FROM DUAL
163: WHERE p_price_type_tbl(i) IS NOT NULL
164: AND p_entity_type_tbl(i) IS NOT NULL
165: AND p_entity_id_tbl(i) IS NOT NULL
166: AND (EXISTS(SELECT 1

Line 483: FROM DUAL

479: p_style_id_tbl(i),
480: 'STYLE_ID',
481: p_style_id_tbl(i),
482: PO_VAL_CONSTANTS.c_price_diff_style_info
483: FROM DUAL
484: WHERE EXISTS(SELECT 1
485: FROM po_doc_style_headers pdsh
486: WHERE pdsh.style_id = p_style_id_tbl(i) AND
487: NVL(pdsh.price_differentials_flag, 'N') = 'N');