DBA Data[Home] [Help]

APPS.PO_PDOI_PREPROC_PVT dependencies on DUAL

Line 1181: FROM DUAL

1177: -- outside of the effective dates of the blanket being expired
1178: IF (p_ga_flag = 'Y') THEN
1179: SELECT MAX('Y')
1180: INTO l_rel_exists
1181: FROM DUAL
1182: WHERE EXISTS (SELECT 'Exists std PO ref the orig GA'
1183: FROM po_lines_all POL,
1184: po_headers_all POH
1185: WHERE POL.from_header_id = p_po_header_id

Line 1208: FROM DUAL

1204: d_position := 20;
1205:
1206: SELECT MAX('Y')
1207: INTO l_rel_exists
1208: FROM DUAL
1209: WHERE EXISTS (SELECT 'release exist after expiration date'
1210: FROM po_releases POR
1211: WHERE POR.po_header_id = p_po_header_id
1212: AND POR.release_date >= l_exp_date);