APPS.PO_VAL_LINES2 dependencies on PO_DOC_STYLE_VALUES

Line 2537: FROM po_doc_style_values pdv

2533: WHERE p_style_id_tbl(i) IS NOT NULL AND
2534: pdsh.style_id = p_style_id_tbl(i) AND
2535: pdsh.line_type_allowed = 'SPECIFIED' AND
2536: NOT EXISTS(SELECT 1
2537: FROM po_doc_style_values pdv
2538: WHERE pdv.style_id = pdsh.style_id
2539: AND pdv.style_attribute_name = 'LINE_TYPES'
2540: AND pdv.style_allowed_value = to_char(p_line_type_id_tbl(i))
2541: AND nvl(pdv.enabled_flag, 'N') = 'Y');

Line 2576: FROM po_doc_style_values pdsv

2572: p_purchase_basis_tbl(i),
2573: PO_VAL_CONSTANTS.c_line_style_on_purchase_basis
2574: FROM DUAL
2575: WHERE NOT EXISTS(SELECT 1
2576: FROM po_doc_style_values pdsv
2577: WHERE pdsv.style_id = p_style_id_tbl(i)
2578: AND pdsv.style_attribute_name = 'PURCHASE_BASES'
2579: AND pdsv.style_allowed_value = p_purchase_basis_tbl(i)
2580: AND nvl(pdsv.enabled_flag, 'N') = 'Y');