APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on DUAL

Line 418: FROM dual

414: --SQL Why: Need to figure out if the change triggers a change to approval
415: -- status
416: SELECT MAX(FND_API.G_TRUE)
417: INTO l_different
418: FROM dual
419: WHERE EXISTS
420: ( SELECT NULL
421: FROM po_headers_draft_all PHD,
422: po_headers_all PH

Line 520: FROM dual

516: d_position := 10;
517: -- Change auth status if there is a new line
518: SELECT MAX(FND_API.G_TRUE)
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

Line 551: FROM dual

547: --SQL Why: Need to figure out if the change triggers a change to approval
548: -- status
549: SELECT MAX(FND_API.G_TRUE)
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

Line 668: FROM dual

664: d_position := 10;
665: -- Change auth status if there is a new line
666: SELECT MAX(FND_API.G_TRUE)
667: INTO l_has_new_records
668: FROM dual
669: WHERE EXISTS
670: ( SELECT NULL
671: FROM po_line_locations_draft_all PLLD
672: WHERE PLLD.draft_id = p_draft_info.draft_id

Line 791: FROM dual

787: d_position := 10;
788: -- Change auth status if there is a new line
789: SELECT MAX(FND_API.G_TRUE)
790: INTO l_has_new_records
791: FROM dual
792: WHERE EXISTS
793: ( SELECT NULL
794: FROM po_distributions_draft_all PDD
795: WHERE PDD.draft_id = p_draft_info.draft_id