DBA Data[Home] [Help]

APPS.PO_DOC_STYLE_PVT dependencies on PO_DOC_STYLE_VALUES

Line 687: FROM po_doc_style_values pdsv,

683: d_progress := '010';
684:
685: SELECT pdsh.line_type_allowed
686: INTO x_related_line_types
687: FROM po_doc_style_values pdsv,
688: po_doc_style_headers pdsh
689: WHERE pdsh.style_id = p_style_id
690: AND pdsv.style_id = pdsh.style_id
691: AND pdsv.style_attribute_name = 'PURCHASE_BASES'

Line 765: FROM PO_DOC_STYLE_VALUES pdv

761: INTO l_count
762: FROM dual
763: WHERE exists
764: (SELECT NULL
765: FROM PO_DOC_STYLE_VALUES pdv
766: WHERE pdv.style_id = p_style_id
767: AND pdv.style_attribute_name = 'LINE_TYPES'
768: AND pdv.style_allowed_value = to_char(p_line_type_id)
769: AND nvl(pdv.enabled_flag,