DBA Data[Home] [Help]

APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 523: FROM po_lines_draft_all PLD

519: INTO l_has_new_records
520: FROM dual
521: WHERE EXISTS
522: ( SELECT NULL
523: FROM po_lines_draft_all PLD
524: WHERE PLD.draft_id = p_draft_info.draft_id
525: AND NVL(PLD.delete_flag, 'N') = 'N'
526: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
527: AND NOT EXISTS

Line 554: FROM po_lines_draft_all PLD,

550: INTO l_different
551: FROM dual
552: WHERE EXISTS
553: ( SELECT NULL
554: FROM po_lines_draft_all PLD,
555: po_lines_all PL
556: WHERE PLD.draft_id = p_draft_info.draft_id
557: AND NVL(PLD.delete_flag, 'N') = 'N'
558: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'