APPS.PAAP_PWP_PKG dependencies on DUAL

Line 453: and hold_lookup_code not in (select decode(FND_PROFILE.value('PA_PAY_WHEN_PAID'),'N','Pay When Paid','Y','#######','Pay When Paid') from dual);

449: select hold_lookup_code from ap_holds_all
450: where invoice_id= p_invoice_id
451: and hold_lookup_code in ('Pay When Paid','PO Deliverable','Project Hold') --bug 9525493
452: and release_reason IS NULL
453: and hold_lookup_code not in (select decode(FND_PROFILE.value('PA_PAY_WHEN_PAID'),'N','Pay When Paid','Y','#######','Pay When Paid') from dual);
454:
455: Cursor c12(p_invoice_id Number, p_hold_type VARCHAR2) Is
456: select hold_lookup_code from ap_holds_all
457: where invoice_id= p_invoice_id

Line 1243: FROM dual;

1239:
1240: -- L_PA_PWP_AP_HDR_ID:= PA_PWP_AP_INV_HDR_S.nextval; Changed for backward compatibility : Bug 7666516
1241: SELECT PA_PWP_AP_INV_HDR_S.nextval
1242: INTO L_PA_PWP_AP_HDR_ID
1243: FROM dual;
1244:
1245: IF P_DEBUG_MODE = 'Y' THEN
1246: log_message('Before inserting record in PA_PWP_AP_INV_HDR'||
1247: '[INVREC.INVOICE_ID : '||INVREC.INVOICE_ID||'] '||