APPS.PA_CC_TRANSFER_PRICE dependencies on PA_IMPLEMENTATIONS

Line 2101: from pa_implementations_all

2097: AND org_information_context = 'Operating Unit Information';
2098:
2099: /* Commented for bug 4920063. Added Above statement for LE
2100: select legal_entity_id
2101: from pa_implementations_all
2102: where org_id = p_org_id;*/
2103:
2104: /*l_legal_entity pa_implementations_all.legal_entity_id%TYPE; Commented for bug 2920063*/
2105:

Line 2104: /*l_legal_entity pa_implementations_all.legal_entity_id%TYPE; Commented for bug 2920063*/

2100: select legal_entity_id
2101: from pa_implementations_all
2102: where org_id = p_org_id;*/
2103:
2104: /*l_legal_entity pa_implementations_all.legal_entity_id%TYPE; Commented for bug 2920063*/
2105:
2106: l_legal_entity hr_organization_information.org_information2%TYPE;
2107:
2108: BEGIN

Line 2216: from pa_implementations;

2212: cursor c_ou_attributes
2213: is
2214: select org_id,business_group_id,cc_default_rate_type,cc_default_rate_date_code,
2215: EXP_ORG_STRUCTURE_VERSION_ID
2216: from pa_implementations;
2217:
2218: cursor c_ou_attributes_fcst (l_org_id number)
2219: is
2220: select org_id,business_group_id,cc_default_rate_type,cc_default_rate_date_code,

Line 2222: from pa_implementations_all

2218: cursor c_ou_attributes_fcst (l_org_id number)
2219: is
2220: select org_id,business_group_id,cc_default_rate_type,cc_default_rate_date_code,
2221: EXP_ORG_STRUCTURE_VERSION_ID
2222: from pa_implementations_all
2223: where org_id = l_org_id;
2224:
2225: cursor c_ou_curr_code_fcst (l_org_id Number)
2226: is

Line 2230: PA_IMPLEMENTATIONS_ALL IMP

2226: is
2227: SELECT FC.Currency_Code
2228: FROM FND_CURRENCIES FC,
2229: GL_SETS_OF_BOOKS GB,
2230: PA_IMPLEMENTATIONS_ALL IMP
2231: WHERE FC.Currency_Code = DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
2232: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
2233: AND IMP.Org_Id = l_org_id;
2234:

Line 2235: l_provider_org_id pa_implementations.org_id%type;

2231: WHERE FC.Currency_Code = DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
2232: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
2233: AND IMP.Org_Id = l_org_id;
2234:
2235: l_provider_org_id pa_implementations.org_id%type;
2236:
2237: BEGIN
2238: pa_debug.Set_err_stack ('Get_Provider_Attributes');
2239: pa_debug.G_Err_Stage := 'Inside Get_Provider_Attributes';

Line 2899: from pa_implementations_all

2895:
2896: if ( nvl(G_prev_rcvr_org_id,-1) <> nvl(p_recvr_org_id,-1) ) then
2897: G_prev_rcvr_org_id := p_recvr_org_id;
2898: select PROJ_ORG_STRUCTURE_VERSION_ID into G_prj_org_struct_ver_id
2899: from pa_implementations_all
2900: where org_id = nvl(G_prev_rcvr_org_id,-1); /* For Bug 5900371. Modified nvl(org_id,-1) to org_id as Org_id is mandatory in R12 and hence can never be Null */
2901: end if;
2902:
2903: