APPS.PO_DOCUMENT_CONTROL_GRP dependencies on PO_RELEASES

Line 414: FROM po_releases_all

410: IF (p_doc_type = 'RELEASE') THEN
411:
412: SELECT authorization_status
413: INTO l_old_auth_status
414: FROM po_releases_all
415: WHERE po_release_id = l_doc_id;
416:
417: ELSE
418:

Line 1187: po_releases por

1183: -- SQL Join: po_header_id
1184: SELECT poh.po_header_id, por.po_release_id
1185: INTO l_release_po_header_id, x_doc_id
1186: FROM po_headers poh,
1187: po_releases por
1188: WHERE poh.segment1 = p_doc_num AND
1189: poh.type_lookup_code = l_release_po_subtype AND
1190: por.po_header_id = poh.po_header_id AND
1191: por.release_num = p_release_num;

Line 1199: po_releases por

1195: -- SQL Join: po_header_id
1196: SELECT poh.po_header_id, por.po_release_id
1197: INTO l_release_po_header_id, x_doc_id
1198: FROM po_headers poh,
1199: po_releases por
1200: WHERE poh.po_header_id = p_doc_id AND
1201: por.po_header_id = poh.po_header_id AND
1202: por.release_num = p_release_num;
1203: END IF; --

Line 1208: FROM po_releases por

1204:
1205: ELSE
1206: SELECT por.po_header_id
1207: INTO l_release_po_header_id
1208: FROM po_releases por
1209: WHERE por.po_release_id = x_doc_id;
1210: END IF; --
1211:
1212: IF (g_fnd_debug = 'Y') THEN