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.

APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_BUDGET_LINES

Line 2971: from pa_budget_lines

2967: where project_id = c_project_id;
2968:
2969: CURSOR get_txn_currency_code (p_resource_assignment_id NUMBER) IS
2970: select txn_currency_code
2971: from pa_budget_lines
2972: where resource_assignment_id = p_resource_assignment_id
2973: and rownum = 1;
2974:
2975: l_add_cnt NUMBER := 0;

Line 3028: pa_budget_lines bl,

3024: pa_copy_asgmts_temp temp,
3025: pa_proj_element_versions pev,
3026: pa_resource_assignments ra,
3027: pa_project_assignments asgn,
3028: pa_budget_lines bl,
3029: pa_resource_list_members rlm,
3030: pa_res_formats_b rf
3031: WHERE
3032: pev.element_version_id = temp.src_elem_ver_id AND

Line 3133: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)

3129: ra.resource_class_code IN ( p_res_class1 , p_res_class2 , p_res_class3, p_res_class4 ) AND
3130: rlm.resource_list_member_id = ra.resource_list_member_id AND
3131: rf.res_format_id = rlm.res_format_id AND
3132: NOT EXISTS
3133: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)
3134: ) ORDER BY 5;
3135:
3136: CURSOR c_get_asgmts_for_copy_proj(p_res_class1 VARCHAR2, p_res_class2 VARCHAR2, p_res_class3 VARCHAR2, p_res_class4 VARCHAR2) IS
3137: SELECT * FROM

Line 3184: pa_budget_lines bl,

3180: pa_copy_asgmts_temp temp,
3181: pa_proj_element_versions pev,
3182: pa_resource_assignments ra,
3183: pa_project_assignments asgn,
3184: pa_budget_lines bl,
3185: pa_resource_list_members source_rlm,
3186: pa_resource_list_members target_rlm,
3187: pa_res_formats_b rf
3188: WHERE

Line 3301: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)

3297: decode(ra.project_assignment_id, -1, NULL, ra.project_assignment_id) = asgn.assignment_id(+) AND
3298: ra.resource_class_code IN ( p_res_class1 , p_res_class2 , p_res_class3, p_res_class4 ) AND
3299: rf.res_format_id = target_rlm.res_format_id AND
3300: NOT EXISTS
3301: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)
3302: ) ORDER BY 5;
3303:
3304:
3305: l_num_of_tasks NUMBER;

Line 5610: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

5606: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5607:
5608: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5609:
5610: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5611:
5612: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5613:
5614: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

Line 5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5629:
5630: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5631:
5632:
5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:
5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5631:
5632:
5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:
5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5638:
5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:
5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5638:
5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5640:
5641:

Line 5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5638:
5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5640:
5641:
5642:
5643: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

Line 5643: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5640:
5641:
5642:
5643: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5644:
5645: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5646:
5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;

Line 5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5645: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5646:
5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5648:
5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5650:
5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5652:
5653: l_margin_txn_cur NUMBER;

Line 5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5648:
5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5650:
5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5652:
5653: l_margin_txn_cur NUMBER;
5654:
5655: l_margin_proj_cur NUMBER;

Line 5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5657: l_margin_proj_func_cur NUMBER;
5658:
5659: l_margin_pct NUMBER;
5660:
5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5662:
5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5659: l_margin_pct NUMBER;
5660:
5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5662:
5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5666:
5667: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5662:
5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5666:
5667: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5668:
5669: l_return_status VARCHAR2(1);

Line 5667: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5666:
5667: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5668:
5669: l_return_status VARCHAR2(1);
5670:
5671: l_msg_count NUMBER;

Line 5678: FROM pa_budget_lines bl

5674:
5675:
5676: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5677: SELECT bl.txn_currency_code
5678: FROM pa_budget_lines bl
5679: WHERE bl.resource_assignment_id = p_resource_assignment_id
5680: AND rownum = 1;
5681:
5682:

Line 5793: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

5789: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5790:
5791: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5792:
5793: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5794:
5795: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5796:
5797: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

Line 5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5812:
5813: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5814:
5815:
5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:
5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5814:
5815:
5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:
5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5821:
5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:
5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5821:
5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5823:
5824:

Line 5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5821:
5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5823:
5824:
5825:
5826: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

Line 5826: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5823:
5824:
5825:
5826: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;
5827:
5828: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5829:
5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;

Line 5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5828: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5829:
5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5831:
5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5833:
5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5835:
5836: l_margin_txn_cur NUMBER;

Line 5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5831:
5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5833:
5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5835:
5836: l_margin_txn_cur NUMBER;
5837:
5838: l_margin_proj_cur NUMBER;

Line 5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5840: l_margin_proj_func_cur NUMBER;
5841:
5842: l_margin_pct NUMBER;
5843:
5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5845:
5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5842: l_margin_pct NUMBER;
5843:
5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5845:
5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5849:
5850: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5845:
5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5849:
5850: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5851:
5852: l_return_status VARCHAR2(1);

Line 5850: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5849:
5850: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5851:
5852: l_return_status VARCHAR2(1);
5853:
5854: l_msg_count NUMBER;

Line 5861: FROM pa_budget_lines bl

5857:
5858:
5859: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5860: SELECT bl.txn_currency_code
5861: FROM pa_budget_lines bl
5862: WHERE bl.resource_assignment_id = p_resource_assignment_id
5863: AND rownum = 1;
5864:
5865:

Line 5996: FROM pa_budget_lines bl

5992: SUM(bl.init_burdened_cost) as act_bur_cost_pfc_cur,
5993: SUM(bl.init_raw_cost) as act_raw_cost_pfc_cur,
5994: AVG(nvl(bl.txn_cost_rate_override, bl.txn_standard_cost_rate)) as avg_raw_cost_rate,
5995: AVG(bl.burden_cost_rate) as avg_bur_cost_rate
5996: FROM pa_budget_lines bl
5997: WHERE bl.resource_assignment_id = p_resource_assignment_id
5998: GROUP BY bl.resource_assignment_id;
5999:
6000: l_act_bur_cost_pc_cur NUMBER;

Line 6106: FROM pa_budget_lines bl

6102:
6103: /* Commented for bug 9675606
6104: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
6105: SELECT bl.txn_currency_code as txn_currency_code
6106: FROM pa_budget_lines bl
6107: WHERE bl.resource_assignment_id = p_resource_assignment_id
6108: AND rownum = 1;
6109: */
6110: