APPS.PA_CC_TRANSFER_PRICE dependencies on PA_IMPLEMENTATIONS_ALL

Line 2005: from pa_implementations_all

2001: AND org_information_context = 'Operating Unit Information';
2002:
2003: /* Commented for bug 4920063. Added Above statement for LE
2004: select legal_entity_id
2005: from pa_implementations_all
2006: where org_id = p_org_id;*/
2007:
2008: /*l_legal_entity pa_implementations_all.legal_entity_id%TYPE; Commented for bug 2920063*/
2009:

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

2004: select legal_entity_id
2005: from pa_implementations_all
2006: where org_id = p_org_id;*/
2007:
2008: /*l_legal_entity pa_implementations_all.legal_entity_id%TYPE; Commented for bug 2920063*/
2009:
2010: l_legal_entity hr_organization_information.org_information2%TYPE;
2011:
2012: BEGIN

Line 2126: from pa_implementations_all

2122: cursor c_ou_attributes_fcst (l_org_id number)
2123: is
2124: select org_id,business_group_id,cc_default_rate_type,cc_default_rate_date_code,
2125: EXP_ORG_STRUCTURE_VERSION_ID
2126: from pa_implementations_all
2127: where org_id = l_org_id;
2128:
2129: cursor c_ou_curr_code_fcst (l_org_id Number)
2130: is

Line 2134: PA_IMPLEMENTATIONS_ALL IMP

2130: is
2131: SELECT FC.Currency_Code
2132: FROM FND_CURRENCIES FC,
2133: GL_SETS_OF_BOOKS GB,
2134: PA_IMPLEMENTATIONS_ALL IMP
2135: WHERE FC.Currency_Code = DECODE(IMP.Set_Of_Books_ID, Null, Null,GB.CURRENCY_CODE)
2136: AND GB.Set_Of_Books_ID = IMP.Set_Of_Books_ID
2137: AND IMP.Org_Id = l_org_id;
2138:

Line 2803: from pa_implementations_all

2799:
2800: if ( nvl(G_prev_rcvr_org_id,-1) <> nvl(p_recvr_org_id,-1) ) then
2801: G_prev_rcvr_org_id := p_recvr_org_id;
2802: select PROJ_ORG_STRUCTURE_VERSION_ID into G_prj_org_struct_ver_id
2803: from pa_implementations_all
2804: 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 */
2805: end if;
2806:
2807: