APPS.PA_PLAN_REVENUE dependencies on PA_IMPLEMENTATIONS_ALL

Line 83: l_PROJ_ORG_STRUCT_VERSION_ID pa_implementations_all.PROJ_ORG_STRUCTURE_VERSION_ID%TYPE;

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

Line 107: from pa_implementations_all i

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