APPS.PO_VAL_LINES2 dependencies on PO_DOC_STYLE_VALUES

Line 2598: FROM po_doc_style_values pdv

2594: WHERE p_style_id_tbl(i) IS NOT NULL AND
2595: pdsh.style_id = p_style_id_tbl(i) AND
2596: pdsh.line_type_allowed = 'SPECIFIED' AND
2597: NOT EXISTS(SELECT 1
2598: FROM po_doc_style_values pdv
2599: WHERE pdv.style_id = pdsh.style_id
2600: AND pdv.style_attribute_name = 'LINE_TYPES'
2601: AND pdv.style_allowed_value = to_char(p_line_type_id_tbl(i))
2602: AND nvl(pdv.enabled_flag, 'N') = 'Y');

Line 2637: FROM po_doc_style_values pdsv

2633: p_purchase_basis_tbl(i),
2634: PO_VAL_CONSTANTS.c_line_style_on_purchase_basis
2635: FROM DUAL
2636: WHERE NOT EXISTS(SELECT 1
2637: FROM po_doc_style_values pdsv
2638: WHERE pdsv.style_id = p_style_id_tbl(i)
2639: AND pdsv.style_attribute_name = 'PURCHASE_BASES'
2640: AND pdsv.style_allowed_value = p_purchase_basis_tbl(i)
2641: AND nvl(pdsv.enabled_flag, 'N') = 'Y');