APPS.PAAP_PWP_PKG dependencies on FND_PROFILE

Line 8: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

4: ProjFunc_Curr_Amount Number;
5: Proj_Curr_Amount Number;
6: P_Trans_Amount Number;
7:
8: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
9:
10: ---------------------------------------------------------------------------------------------------------
11: -- This Function returns Project Functional Currency Code
12: ----------------------------------------------------------------------------------------------------------

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