APPS.PA_PLAN_REVENUE dependencies on PA_IMPLEMENTATIONS_ALL

Line 84: l_PROJ_ORG_STRUCT_VERSION_ID pa_implementations_all.PROJ_ORG_STRUCTURE_VERSION_ID%TYPE;

80: l_true BOOLEAN:= FALSE;
81: l_x_return_status VARCHAR2(20):= g_success;
82: l_insufficient_param EXCEPTION;
83: l_no_rate EXCEPTION;
84: l_PROJ_ORG_STRUCT_VERSION_ID pa_implementations_all.PROJ_ORG_STRUCTURE_VERSION_ID%TYPE;
85:
86: BEGIN
87: /*Checking all the mandatory Parameters */
88:

Line 108: from pa_implementations_all i

104: into l_rate,l_markup_percentage,l_uom,l_rate_currency_code;
105: begin
106: select i. PROJ_ORG_STRUCTURE_VERSION_ID
107: into l_PROJ_ORG_STRUCT_VERSION_ID
108: from pa_implementations_all i
109: where NVL(i.org_id,-99) = NVL(p_org_id,-99);
110: exception
111: when no_data_found then
112: null;