APPS.PO_DOCUMENT_REVISION_GRP dependencies on DUAL

Line 175: FROM dual

171: -- p_keey_summary = 'Y'
172: BEGIN
173: SELECT 'N'
174: INTO l_keep_summary
175: FROM dual
176: WHERE exists (SELECT 'approved document'
177: FROM po_headers
178: WHERE po_header_id = p_doc_id
179: AND NVL(approved_flag, 'N') IN ('R', 'Y'));

Line 257: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag

253: */
254: l_progress := '020';
255:
256: IF p_chk_cancel_flag = 'Y' THEN --
257: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag
258:
259: l_need_to_check := PO_Archive_Check(p_doc_id);
260:
261: if (not l_need_to_check) then

Line 471: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag

467:
468: end if;
469:
470: IF p_chk_cancel_flag = 'Y' THEN --
471: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag
472:
473: l_need_to_check := Release_Archive_Check(p_doc_id);
474:
475: if (not l_need_to_check) then

Line 719: from sys.dual

715: Hence donot use the agent_id comparision for cancel flow*/
716:
717: Select 'Y'
718: INTO x_different
719: from sys.dual
720: where exists(
721: select null
722: FROM PO_HEADERS POH,
723: PO_HEADERS_ARCHIVE POHA

Line 891: from sys.dual

887: l_progress := '020';
888: if (p_doc_subtype = 'BLANKET') then
889: Select 'Y'
890: INTO x_different
891: from sys.dual
892: where exists(
893: select null
894: FROM PO_LINES POL,
895: PO_LINES_ARCHIVE POLA

Line 1030: from sys.dual

1026:
1027: else -- (p_doc_subtype = 'BLANKET') */
1028: Select 'Y'
1029: INTO x_different
1030: from sys.dual
1031: where exists(
1032: select null
1033: FROM PO_LINES POL,
1034: PO_LINES_ARCHIVE POLA

Line 1220: from sys.dual

1216:
1217: elsif(p_element = 'PORCH_SHIPMENTS') then --p_element='PORCH_HEADER'*/
1218: Select 'Y'
1219: INTO x_different
1220: from sys.dual
1221: where exists(
1222: select null
1223: FROM PO_LINE_LOCATIONS POLL,
1224: PO_LINE_LOCATIONS_ARCHIVE POLLA

Line 1311: from sys.dual

1307: ** since print changed orders report does not cover that case.
1308: */
1309: Select 'Y'
1310: INTO x_different
1311: from sys.dual
1312: where exists(
1313: select null
1314: FROM PO_LINE_LOCATIONS POLL,
1315: PO_LINE_LOCATIONS_ARCHIVE POLLA

Line 1430: from sys.dual

1426:
1427: elsif (p_element = 'PORCH_DISTRIBUTIONS') then --p_element='PORCH_HEADER'*/
1428: Select 'Y'
1429: INTO x_different
1430: from sys.dual
1431: where exists(
1432: select null
1433: FROM PO_DISTRIBUTIONS POD,
1434: PO_DISTRIBUTIONS_ARCHIVE PODA

Line 1494: from sys.dual

1490: Hence donot use the agent_id comparision for cancel flow*/
1491:
1492: Select 'Y'
1493: INTO x_different
1494: from sys.dual
1495: where exists(
1496: select null
1497: FROM PO_RELEASES POR,
1498: PO_RELEASES_ARCHIVE PORA

Line 1540: from sys.dual

1536:
1537: elsif(p_element = 'PORCH_SHIPMENTS') then --p_element='PORCH_HEADER'*/
1538: Select 'Y'
1539: INTO x_different
1540: from sys.dual
1541: where exists(
1542: select null
1543: FROM PO_LINE_LOCATIONS POLL,
1544: PO_LINE_LOCATIONS_ARCHIVE POLLA

Line 1607: from sys.dual

1603:
1604: elsif (p_element = 'PORCH_DISTRIBUTIONS') then --p_element='PORCH_HEADER'*/
1605: Select 'Y'
1606: INTO x_different
1607: from sys.dual
1608: where exists(
1609: select null
1610: FROM PO_DISTRIBUTIONS POD,
1611: PO_DISTRIBUTIONS_ARCHIVE PODA