DBA Data[Home] [Help]

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_LINES_S

Line 188: pa_budget_lines sbl,

184: NULL,
185: NULL,
186: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
187: FROM pa_res_list_map_tmp4 tmp4,
188: pa_budget_lines sbl,
189: pa_resource_assignments ra,
190: pa_tasks ta /* Added for ER 4376722 */
191: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
192: and sbl.budget_version_id = l_source_id

Line 288: pa_budget_lines sbl,

284: NULL,
285: NULL,
286: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
287: FROM pa_res_list_map_tmp4 tmp4,
288: pa_budget_lines sbl,
289: pa_resource_assignments ra,
290: pa_tasks ta /* Added for ER 4376722 */
291: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
292: and sbl.budget_version_id = l_source_id

Line 359: pa_budget_lines sbl,

355: NULL,
356: NULL,
357: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
358: FROM pa_res_list_map_tmp4 tmp4,
359: pa_budget_lines sbl,
360: pa_resource_assignments ra,
361: pa_tasks ta /* Added for ER 4376722 */
362: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
363: and sbl.budget_version_id = l_source_id

Line 2898: pa_budget_lines sbl,

2894: NULL,
2895: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2896: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2897: FROM pa_res_list_map_tmp4 tmp4,
2898: pa_budget_lines sbl,
2899: pa_resource_assignments ra,
2900: pa_tasks ta /* Added for ER 4376722 */
2901: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2902: and sbl.budget_version_id = p_source_bv_id

Line 2988: pa_budget_lines sbl,

2984: NULL,
2985: NVL(ta.billable_flag,'Y'),
2986: avg(sbl.txn_markup_percent) -- Bug #13552225
2987: FROM pa_res_list_map_tmp4 tmp4,
2988: pa_budget_lines sbl,
2989: pa_resource_assignments ra,
2990: pa_tasks ta
2991: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2992: and sbl.budget_version_id = p_source_bv_id

Line 3084: pa_budget_lines sbl,

3080: NULL,
3081: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3082: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3083: FROM pa_res_list_map_tmp4 tmp4,
3084: pa_budget_lines sbl,
3085: pa_resource_assignments ra,
3086: pa_tasks ta /* Added for ER 4376722 */
3087: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3088: and sbl.budget_version_id = p_source_bv_id

Line 3181: pa_budget_lines sbl,

3177: NULL,
3178: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3179: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3180: FROM pa_res_list_map_tmp4 tmp4,
3181: pa_budget_lines sbl,
3182: pa_resource_assignments ra,
3183: pa_tasks ta /* Added for ER 4376722 */
3184: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3185: and sbl.budget_version_id = p_source_bv_id

Line 5356: pa_budget_lines_s.nextval,

5352: TXN_COST_RATE_OVERRIDE,
5353: BURDEN_COST_RATE_OVERRIDE,
5354: TXN_BILL_RATE_OVERRIDE)
5355: VALUES (
5356: pa_budget_lines_s.nextval,
5357: P_TARGET_BV_ID,
5358: l_ins_tgt_res_asg_id_tab(i),
5359: l_ins_start_date_tab(i),
5360: l_ins_txn_currency_code_tab(i),

Line 5489: pa_budget_lines_s.nextval,

5485: BURDEN_COST_RATE_OVERRIDE,
5486: TXN_BILL_RATE_OVERRIDE,
5487: TXN_MARKUP_PERCENT ) /* Added for Bug 5166047 */
5488: VALUES (
5489: pa_budget_lines_s.nextval,
5490: P_TARGET_BV_ID,
5491: l_tgt_res_asg_id_tab(i),
5492: l_start_date_tab(i),
5493: l_txn_currency_code_tab(i),