APPS.PA_FI_AMT_CALC_PKG dependencies on PA_IMPLEMENTATIONS

Line 28: pa_implementations imp

24: SELECT
25: Org.CHILD_ORGANIZATION_ID organization_id
26: FROM
27: pa_org_hierarchy_denorm org,
28: pa_implementations imp
29: WHERE Org.PA_ORG_USE_TYPE='REPORTING' and
30: Org.PARENT_ORGANIZATION_ID=c_organization_Id and
31: /* Bug fix: 4367847 NVL(org.ORG_ID,-99)=NVL(imp.ORG_ID,-99) and */
32: org.ORG_ID = imp.ORG_ID and

Line 70: l_excep_org_id FROM PA_IMPLEMENTATIONS;

66: END IF;
67:
68: /* Bug fix: 4367847 */
69: SELECT NVL(org_id,-99) INTO
70: l_excep_org_id FROM PA_IMPLEMENTATIONS;
71:
72: If P_PA_DEBUG_MODE = 'Y' THEN
73: PA_DEBUG.Log_Message(p_message => 'l_excep_org_id => :'||l_excep_org_id);
74: PA_DEBUG.Log_Message(p_message => 'Calling MO_GLOBAL.INITapi');

Line 140: l_excep_org_id FROM PA_IMPLEMENTATIONS;

136: END IF;
137:
138:
139: SELECT NVL(org_id,-99) INTO
140: l_excep_org_id FROM PA_IMPLEMENTATIONS;
141:
142: /* Bug fix: 4367847 */
143: If P_PA_DEBUG_MODE = 'Y' THEN
144: PA_DEBUG.Log_Message(p_message => 'Calling FND_REQUEST.set_org_id{'||l_excep_org_id||'}');

Line 406: Pa_Implementations_All imp,

402: imp.Pa_Period_Type Pa_Period_Type,
403: sob.PERIOD_SET_NAME PERIOD_SET_NAME,
404: sob.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE
405: FROM Pa_Forecasting_Options_All fcst,
406: Pa_Implementations_All imp,
407: Gl_Sets_Of_Books sob
408: WHERE /* Bug fix:4367847 NVL(imp.Org_Id,-99) = NVL(fcst.Org_Id,-99) AND */
409: imp.Org_Id = NVL(fcst.Org_Id,-99) AND
410: sob.SET_OF_BOOKS_ID = imp.SET_OF_BOOKS_ID;