DBA Data[Home] [Help]

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_LINES_S

Line 153: pa_budget_lines sbl,

149: NULL,
150: NULL,
151: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
152: FROM pa_res_list_map_tmp4 tmp4,
153: pa_budget_lines sbl,
154: pa_resource_assignments ra,
155: pa_tasks ta /* Added for ER 4376722 */
156: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
157: and sbl.budget_version_id = l_source_id

Line 253: pa_budget_lines sbl,

249: NULL,
250: NULL,
251: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
252: FROM pa_res_list_map_tmp4 tmp4,
253: pa_budget_lines sbl,
254: pa_resource_assignments ra,
255: pa_tasks ta /* Added for ER 4376722 */
256: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
257: and sbl.budget_version_id = l_source_id

Line 324: pa_budget_lines sbl,

320: NULL,
321: NULL,
322: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
323: FROM pa_res_list_map_tmp4 tmp4,
324: pa_budget_lines sbl,
325: pa_resource_assignments ra,
326: pa_tasks ta /* Added for ER 4376722 */
327: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
328: and sbl.budget_version_id = l_source_id

Line 2821: pa_budget_lines sbl,

2817: NULL,
2818: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2819: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2820: FROM pa_res_list_map_tmp4 tmp4,
2821: pa_budget_lines sbl,
2822: pa_resource_assignments ra,
2823: pa_tasks ta /* Added for ER 4376722 */
2824: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2825: and sbl.budget_version_id = p_source_bv_id

Line 2910: pa_budget_lines sbl,

2906: NULL,
2907: NULL,
2908: NVL(ta.billable_flag,'Y')
2909: FROM pa_res_list_map_tmp4 tmp4,
2910: pa_budget_lines sbl,
2911: pa_resource_assignments ra,
2912: pa_tasks ta
2913: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2914: and sbl.budget_version_id = p_source_bv_id

Line 3006: pa_budget_lines sbl,

3002: NULL,
3003: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3004: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3005: FROM pa_res_list_map_tmp4 tmp4,
3006: pa_budget_lines sbl,
3007: pa_resource_assignments ra,
3008: pa_tasks ta /* Added for ER 4376722 */
3009: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3010: and sbl.budget_version_id = p_source_bv_id

Line 3103: pa_budget_lines sbl,

3099: NULL,
3100: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3101: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3102: FROM pa_res_list_map_tmp4 tmp4,
3103: pa_budget_lines sbl,
3104: pa_resource_assignments ra,
3105: pa_tasks ta /* Added for ER 4376722 */
3106: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3107: and sbl.budget_version_id = p_source_bv_id

Line 5277: pa_budget_lines_s.nextval,

5273: TXN_COST_RATE_OVERRIDE,
5274: BURDEN_COST_RATE_OVERRIDE,
5275: TXN_BILL_RATE_OVERRIDE)
5276: VALUES (
5277: pa_budget_lines_s.nextval,
5278: P_TARGET_BV_ID,
5279: l_ins_tgt_res_asg_id_tab(i),
5280: l_ins_start_date_tab(i),
5281: l_ins_txn_currency_code_tab(i),

Line 5410: pa_budget_lines_s.nextval,

5406: BURDEN_COST_RATE_OVERRIDE,
5407: TXN_BILL_RATE_OVERRIDE,
5408: TXN_MARKUP_PERCENT ) /* Added for Bug 5166047 */
5409: VALUES (
5410: pa_budget_lines_s.nextval,
5411: P_TARGET_BV_ID,
5412: l_tgt_res_asg_id_tab(i),
5413: l_start_date_tab(i),
5414: l_txn_currency_code_tab(i),