DBA Data[Home] [Help]

APPS.PO_VAL_HEADERS dependencies on DUAL

Line 640: FROM DUAL

636: , p_header_id_tbl(i)
637: , c_START_DATE
638: , TO_CHAR(p_start_date_tbl(i))
639: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR --- Bug 5548899
640: FROM DUAL
641: WHERE
642: p_type_lookup_code_tbl(i) = c_BLANKET
643: AND EXISTS
644: ( SELECT NULL

Line 718: FROM DUAL

714: , p_header_id_tbl(i)
715: , c_END_DATE
716: , TO_CHAR(p_end_date_tbl(i))
717: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR --- Bug 5548899
718: FROM DUAL
719: WHERE
720: p_type_lookup_code_tbl(i) = c_BLANKET
721: AND EXISTS
722: ( SELECT NULL

Line 795: FROM DUAL

791: , p_header_id_tbl(i)
792: , c_START_DATE
793: , TO_CHAR(p_start_date_tbl(i))
794: , PO_MESSAGE_S.PO_CONTRACT_ST_LT_REF_CR
795: FROM DUAL
796: WHERE
797: p_type_lookup_code_tbl(i) = c_CONTRACT
798: AND EXISTS
799: ( SELECT NULL

Line 879: FROM DUAL

875: , p_header_id_tbl(i)
876: , c_END_DATE
877: , TO_CHAR(p_end_date_tbl(i))
878: , PO_MESSAGE_S.PO_CONTRACT_ST_GT_REF_CR
879: FROM DUAL
880: WHERE
881: p_type_lookup_code_tbl(i) = c_CONTRACT
882: AND EXISTS
883: ( SELECT NULL