APPS.QP_PRICE_BOOK_UTIL dependencies on DUAL

Line 718: FROM dual

714:
715: BEGIN
716: SELECT 'Y'
717: INTO l_party_id_match
718: FROM dual
719: WHERE EXISTS (
720: SELECT 'x'
721: FROM hz_relationships rel, hz_parties party3,
722: hz_parties party4, hz_parties party5

Line 3590: FROM dual;

3586: END IF;
3587:
3588: SELECT FND_PROFILE.VALUE('ORG_ID')
3589: INTO l_operating_unit_id
3590: FROM dual;
3591:
3592: IF (l_debug = FND_API.G_TRUE) THEN
3593: QP_PREQ_GRP.engine_debug('l_operating_unit_id:' || l_operating_unit_id);
3594: END IF;

Line 3652: SELECT QP_XML_MESSAGES_S.NEXTVAL INTO l_syncctlg_seq FROM dual;

3648: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3649: END IF;
3650:
3651: -- create unique key
3652: SELECT QP_XML_MESSAGES_S.NEXTVAL INTO l_syncctlg_seq FROM dual;
3653: IF (l_debug = FND_API.G_TRUE) THEN
3654: QP_PREQ_GRP.engine_debug('l_syncctlg_seq:' || l_syncctlg_seq);
3655: END IF;
3656: l_event_key := to_char(p_price_book_header_id) || '.' || to_char(l_syncctlg_seq);

Line 3658: SELECT SYSDATE INTO l_date FROM dual;

3654: QP_PREQ_GRP.engine_debug('l_syncctlg_seq:' || l_syncctlg_seq);
3655: END IF;
3656: l_event_key := to_char(p_price_book_header_id) || '.' || to_char(l_syncctlg_seq);
3657:
3658: SELECT SYSDATE INTO l_date FROM dual;
3659: IF (l_debug = FND_API.G_TRUE) THEN
3660: QP_PREQ_GRP.engine_debug('l_date:' || l_date);
3661: END IF;
3662: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);