APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_GL_PA_PERIODS_TMP

Line 3942: PA_GL_PA_PERIODS_TMP pa_gl

3938: NULL
3939: FROM PA_FP_CALC_AMT_TMP2 tmp4,
3940: pa_budget_lines sbl,
3941: pa_resource_assignments ra,
3942: PA_GL_PA_PERIODS_TMP pa_gl
3943: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
3944: and (tmp4.TRANSACTION_SOURCE_CODE = 'WORKPLAN_RESOURCES' OR
3945: tmp4.TRANSACTION_SOURCE_CODE = 'FINANCIAL_PLAN')
3946: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id

Line 4015: PA_GL_PA_PERIODS_TMP pa_gl

4011: NULL
4012: FROM PA_FP_CALC_AMT_TMP2 tmp4,
4013: pa_budget_lines sbl,
4014: pa_resource_assignments ra,
4015: PA_GL_PA_PERIODS_TMP pa_gl
4016: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
4017: and tmp4.TRANSACTION_SOURCE_CODE = c_gen_source
4018: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id
4019: and ra.budget_version_id = c_target_bv_id

Line 4087: PA_GL_PA_PERIODS_TMP pa_gl

4083: NULL
4084: FROM PA_FP_CALC_AMT_TMP2 tmp4,
4085: pa_budget_lines sbl,
4086: pa_resource_assignments ra,
4087: PA_GL_PA_PERIODS_TMP pa_gl
4088: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
4089: and (tmp4.TRANSACTION_SOURCE_CODE = 'WORKPLAN_RESOURCES' OR
4090: tmp4.TRANSACTION_SOURCE_CODE = 'FINANCIAL_PLAN')
4091: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id

Line 4160: PA_GL_PA_PERIODS_TMP pa_gl

4156: NULL
4157: FROM PA_FP_CALC_AMT_TMP2 tmp4,
4158: pa_budget_lines sbl,
4159: pa_resource_assignments ra,
4160: PA_GL_PA_PERIODS_TMP pa_gl
4161: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
4162: and tmp4.TRANSACTION_SOURCE_CODE = c_gen_source
4163: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id
4164: and ra.budget_version_id = c_target_bv_id

Line 5170: ** This procedure populates PA_GL_PA_PERIODS_TMP temporary table with all **

5166:
5167:
5168: -- skkoppul added for AAI Requirement - start
5169: /*****************************************************************************
5170: ** This procedure populates PA_GL_PA_PERIODS_TMP temporary table with all **
5171: ** the PA periods to GL period mapping and the conversion mutiplier so **
5172: ** that when converting from larger period like Month to smaller period **
5173: ** like week, the conversion multiplier can be used to distribute amounts **
5174: ** evenly. This procedure only stores the mapping entities for the lowest **

Line 5196: INTO PA_GL_PA_PERIODS_TMP

5192:
5193: -- Get PA to GL mapping periods along with their period names and dates
5194: -- during a time period using the start and end dates
5195: INSERT
5196: INTO PA_GL_PA_PERIODS_TMP
5197: (
5198: PA_PERIOD_NAME ,
5199: GL_PERIOD_NAME ,
5200: PA_START_DATE ,

Line 5231: FROM PA_GL_PA_PERIODS_TMP

5227: SELECT 'Y'
5228: INTO l_is_gl_greater
5229: FROM
5230: (SELECT COUNT(*)
5231: FROM PA_GL_PA_PERIODS_TMP
5232: GROUP BY GL_PERIOD_NAME
5233: HAVING COUNT(*) > 1
5234: )
5235: WHERE rownum = 1;

Line 5246: UPDATE PA_GL_PA_PERIODS_TMP tmp1

5242: -- whichever is the greater time unit, derive a mutiplier for each period
5243: -- by looking into how many smaller periods fall into the larger period
5244: IF l_is_gl_greater = 'Y' THEN
5245:
5246: UPDATE PA_GL_PA_PERIODS_TMP tmp1
5247: SET multiplier =
5248: (SELECT COUNT(*)
5249: FROM PA_GL_PA_PERIODS_TMP tmp2
5250: WHERE tmp1.GL_PERIOD_NAME = tmp2.GL_PERIOD_NAME

Line 5249: FROM PA_GL_PA_PERIODS_TMP tmp2

5245:
5246: UPDATE PA_GL_PA_PERIODS_TMP tmp1
5247: SET multiplier =
5248: (SELECT COUNT(*)
5249: FROM PA_GL_PA_PERIODS_TMP tmp2
5250: WHERE tmp1.GL_PERIOD_NAME = tmp2.GL_PERIOD_NAME
5251: GROUP BY GL_PERIOD_NAME
5252: );
5253: ELSE

Line 5257: UPDATE PA_GL_PA_PERIODS_TMP tmp1

5253: ELSE
5254: -- two cases where l_is_gl_greater is 'N'
5255: -- 1) GL periods (week) have lesser time unit than PA period (month)
5256: -- 2) GL periods (month) have same time unit as PA period (month)
5257: UPDATE PA_GL_PA_PERIODS_TMP tmp1
5258: SET multiplier =
5259: (SELECT COUNT(*)
5260: FROM PA_GL_PA_PERIODS_TMP tmp2
5261: WHERE tmp1.PA_PERIOD_NAME = tmp2.PA_PERIOD_NAME

Line 5260: FROM PA_GL_PA_PERIODS_TMP tmp2

5256: -- 2) GL periods (month) have same time unit as PA period (month)
5257: UPDATE PA_GL_PA_PERIODS_TMP tmp1
5258: SET multiplier =
5259: (SELECT COUNT(*)
5260: FROM PA_GL_PA_PERIODS_TMP tmp2
5261: WHERE tmp1.PA_PERIOD_NAME = tmp2.PA_PERIOD_NAME
5262: GROUP BY PA_PERIOD_NAME
5263: );
5264: END IF;