DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on DUAL

Line 996: FROM dual;

992: END IF;
993:
994: -- Generate next bid number
995: SELECT pon_bid_headers_s.nextval INTO x_bid_number
996: FROM dual;
997:
998: INSERT INTO pon_bid_headers
999: (
1000: BID_NUMBER,

Line 1525: -- In both cases, scores by individual scorers are not copied over -

1521: -- Bug 5046909 - Determine if team scoring is enabled
1522: -- If team scoring is enabled, we do not copy the score over from the
1523: -- earlier bid. If team scoring is not enabled, we copy the score over
1524: -- for a header attribute only if the attribute has not been modified.
1525: -- In both cases, scores by individual scorers are not copied over -
1526: -- only the final one is
1527: -- Adding this SELECT from auction_headers_all - ideally, this should
1528: -- be combined and only one call made for the entire flow...will log a
1529: -- tracking bug for this

Line 4456: FROM dual

4452: -- Else l_can_create_payment = 'N';
4453:
4454: SELECT 'Y'
4455: INTO x_can_create_payments
4456: FROM dual
4457: WHERE EXISTS (SELECT 1
4458: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
4459: PON_BID_ITEM_PRICES pbi,
4460: PON_AUCTION_HEADERS_ALL pah