APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on DUAL

Line 415: FROM DUAL

411: NULL, -- program_application_id
412: NULL, -- program_id
413: NULL, -- program_update_date
414: NULL -- program_date
415: FROM DUAL
416: WHERE NOT EXISTS
417: (SELECT 'Action History Record alreday exists'
418: FROM PO_ACTION_HISTORY POAH
419: WHERE POAH.object_id = p_po_header_ids(i)

Line 822: FROM DUAL;

818: -- SQL Why : To get po_line_id's
819: -- SQL Join: none
820: SELECT PO_SESSION_GT_S.nextval
821: INTO l_key
822: FROM DUAL;
823:
824: l_progress := '030';
825: -- SQL What: Get all the line id's for the given set of header id's
826: -- SQL Why : To archive the GBPA lines.