eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_BUDGET_LINES_S

Line 3804: pa_budget_lines sbl,

3800: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
3801: NULL,
3802: NULL
3803: FROM PA_FP_CALC_AMT_TMP2 tmp4,
3804: pa_budget_lines sbl,
3805: pa_resource_assignments ra
3806: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
3807: and (tmp4.TRANSACTION_SOURCE_CODE = 'WORKPLAN_RESOURCES' OR
3808: tmp4.TRANSACTION_SOURCE_CODE = 'FINANCIAL_PLAN')

Line 3872: pa_budget_lines sbl,

3868: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
3869: NULL,
3870: NULL
3871: FROM PA_FP_CALC_AMT_TMP2 tmp4,
3872: pa_budget_lines sbl,
3873: pa_resource_assignments ra
3874: WHERE tmp4.resource_assignment_id = sbl.resource_assignment_id
3875: and tmp4.TRANSACTION_SOURCE_CODE = c_gen_source
3876: and tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id

Line 3940: pa_budget_lines sbl,

3936: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
3937: NULL,
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

Line 4013: pa_budget_lines sbl,

4009: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate))), --sbl.burdened_cost
4010: NULL,
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

Line 4085: pa_budget_lines sbl,

4081: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate)))/pa_gl.multiplier), --sbl.burdened_cost
4082: NULL,
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

Line 4158: pa_budget_lines sbl,

4154: NVL(sbl.burden_cost_rate_override,sbl.burden_cost_rate)))/pa_gl.multiplier), --sbl.burdened_cost
4155: NULL,
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

Line 4334: pa_budget_lines_s.nextval,

4330: TXN_COST_RATE_OVERRIDE,
4331: BURDEN_COST_RATE_OVERRIDE
4332: )
4333: VALUES (
4334: pa_budget_lines_s.nextval,
4335: P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID,
4336: l_tgt_res_asg_id_tab(i),
4337: l_start_date_tab(i),
4338: l_txn_currency_code_tab(i),

Line 4423: pa_budget_lines_s.nextval,

4419: RAW_COST_SOURCE,
4420: BURDENED_COST_SOURCE,
4421: QUANTITY_SOURCE)
4422: VALUES (
4423: pa_budget_lines_s.nextval,
4424: P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID,
4425: l_tgt_res_asg_id_tab(i),
4426: l_start_date_tab(i),
4427: l_txn_currency_code_tab(i),

Line 4515: pa_budget_lines_s.nextval,

4511: RAW_COST_SOURCE,
4512: BURDENED_COST_SOURCE,
4513: QUANTITY_SOURCE)
4514: VALUES (
4515: pa_budget_lines_s.nextval,
4516: P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID,
4517: l_tgt_res_asg_id_tab(i),
4518: l_start_date_tab(i),
4519: l_txn_currency_code_tab(i),

Line 4680: pa_budget_lines_s.nextval,

4676: RAW_COST_SOURCE,
4677: BURDENED_COST_SOURCE,
4678: QUANTITY_SOURCE)
4679: VALUES (
4680: pa_budget_lines_s.nextval,
4681: P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID,
4682: l_pr_tgt_res_asg_id_tab(i),
4683: l_pr_start_date_tab(i),
4684: l_pr_txn_currency_code_tab(i),

Line 4837: pa_budget_lines_s.nextval,

4833: pbl.RAW_COST_SOURCE,
4834: pbl.BURDENED_COST_SOURCE,
4835: pbl.QUANTITY_SOURCE)
4836: VALUES (
4837: pa_budget_lines_s.nextval,
4838: tmp.BUDGET_VERSION_ID,
4839: tmp.RESOURCE_ASSIGNMENT_ID,
4840: tmp.START_DATE,
4841: tmp.TXN_CURRENCY_CODE,

Line 4998: pa_budget_lines_s.nextval,

4994: pbl.RAW_COST_SOURCE,
4995: pbl.BURDENED_COST_SOURCE,
4996: pbl.QUANTITY_SOURCE)
4997: VALUES (
4998: pa_budget_lines_s.nextval,
4999: tmp.BUDGET_VERSION_ID,
5000: tmp.RESOURCE_ASSIGNMENT_ID,
5001: tmp.START_DATE,
5002: tmp.TXN_CURRENCY_CODE,

Line 5101: pa_budget_lines sbl,

5097: sum(sbl.txn_raw_cost),
5098: sum(sbl.txn_burdened_cost),
5099: 'ETC'
5100: FROM PA_FP_CALC_AMT_TMP2 tmp4,
5101: pa_budget_lines sbl,
5102: pa_resource_assignments ra
5103: WHERE tmp4.TARGET_RES_ASG_ID = ra.resource_assignment_id
5104: AND sbl.resource_assignment_id=ra.resource_assignment_id
5105: AND ra.budget_version_id = P_FP_COLS_TGT_REC.X_BUDGET_VERSION_ID