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 3623: FROM dual;

3619: END IF;
3620:
3621: SELECT FND_PROFILE.VALUE('ORG_ID')
3622: INTO l_operating_unit_id
3623: FROM dual;
3624:
3625: IF (l_debug = FND_API.G_TRUE) THEN
3626: QP_PREQ_GRP.engine_debug('l_operating_unit_id:' || l_operating_unit_id);
3627: END IF;

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

3681: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3682: END IF;
3683:
3684: -- create unique key
3685: SELECT QP_XML_MESSAGES_S.NEXTVAL INTO l_syncctlg_seq FROM dual;
3686: IF (l_debug = FND_API.G_TRUE) THEN
3687: QP_PREQ_GRP.engine_debug('l_syncctlg_seq:' || l_syncctlg_seq);
3688: END IF;
3689: l_event_key := to_char(p_price_book_header_id) || '.' || to_char(l_syncctlg_seq);

Line 3691: SELECT SYSDATE INTO l_date FROM dual;

3687: QP_PREQ_GRP.engine_debug('l_syncctlg_seq:' || l_syncctlg_seq);
3688: END IF;
3689: l_event_key := to_char(p_price_book_header_id) || '.' || to_char(l_syncctlg_seq);
3690:
3691: SELECT SYSDATE INTO l_date FROM dual;
3692: IF (l_debug = FND_API.G_TRUE) THEN
3693: QP_PREQ_GRP.engine_debug('l_date:' || l_date);
3694: END IF;
3695: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);

Line 4536: from dual

4532: PBLinDet.LIST_NAME "ListName",
4533: PBLinDet.LIST_LINE_TYPE "ListLineType",
4534: PBLinDet.PRICE_BREAK_TYPE "PriceBreakType",
4535: DECODE((SELECT ''X''
4536: from dual
4537: where exists(SELECT ''X''
4538: from QP_PRICE_BOOK_ATTRIBUTES_V pba
4539: where pba.PRICE_BOOK_LINE_DET_ID = PBLinDet.PRICE_BOOK_LINE_DET_ID
4540: and pba.PRICE_BOOK_LINE_ID = PBLinDet.PRICE_BOOK_LINE_ID)),''X'',''PricingAttrEnabled'',''PricingAttrDisabled'') "PricingAttribute",

Line 4542: from dual

4538: from QP_PRICE_BOOK_ATTRIBUTES_V pba
4539: where pba.PRICE_BOOK_LINE_DET_ID = PBLinDet.PRICE_BOOK_LINE_DET_ID
4540: and pba.PRICE_BOOK_LINE_ID = PBLinDet.PRICE_BOOK_LINE_ID)),''X'',''PricingAttrEnabled'',''PricingAttrDisabled'') "PricingAttribute",
4541: DECODE((SELECT ''X''
4542: from dual
4543: where exists(SELECT ''X''
4544: from QP_PRICE_BOOK_BREAK_LINES_V pbb
4545: where pbb.PRICE_BOOK_LINE_DET_ID= PBLinDet.PRICE_BOOK_LINE_DET_ID
4546: and pbb.PRICE_BOOK_LINE_ID = PBLinDet.PRICE_BOOK_LINE_ID)),''X'',''BreaksEnabled'',''BreaksDisabled'') "Breaks",

Line 4594: from dual

4590: WHERE PBLinDet.Price_Book_Line_Id = PBLin.Price_Book_Line_Id
4591: )
4592: ),
4593: DECODE((SELECT ''X''
4594: from dual
4595: where exists(SELECT ''X''
4596: from QP_PRICE_BOOK_MESSAGES_V pbm
4597: where pbm.Price_Book_Line_Id = PBLin.Price_Book_Line_Id )),
4598: ''X'',