APPS.PA_PPR_ROLLUP_PVT dependencies on PA_BUDGET_LINES

Line 416: PA_BUDGET_LINES bl ,

412: nvl(b.connect_path , '/'||DECODE(ra.task_id, 0, l_struct_elem_id, ra.task_id) ) ,
413: nvl(b.leaf_node,1) ,
414: nvl(b.wbs_rbs_level,1)
415: FROM PA_RESOURCE_ASSIGNMENTS ra ,
416: PA_BUDGET_LINES bl ,
417: pa_ppr_obj_tmp b
418: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
419: and ra.budget_version_id = l_budget_version_id
420: and ra.task_id = b.object_id

Line 485: PA_BUDGET_LINES bl ,

481: nvl(b.connect_path , '/'||DECODE(ra.task_id, 0, l_struct_elem_id, ra.task_id) ) connect_path,
482: nvl(b.leaf_node,1) leaf_node,
483: nvl(b.wbs_rbs_level,1) task_level_arr
484: FROM PA_RESOURCE_ASSIGNMENTS ra ,
485: PA_BUDGET_LINES bl ,
486: pa_ppr_obj_tmp b
487: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
488: and ra.budget_version_id = l_budget_version_id
489: and ra.task_id = b.object_id

Line 714: PA_BUDGET_LINES bl ,

710: nvl(b.leaf_node,1) ,
711: nvl(b.wbs_rbs_level,1),
712: '/'||decode(p_fact_slice,'RBS',ra.rbs_element_id,'CBS',ra.cbs_element_id,null)
713: FROM PA_RESOURCE_ASSIGNMENTS ra ,
714: PA_BUDGET_LINES bl ,
715: pa_ppr_obj_tmp b
716: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
717: and ra.budget_version_id = l_budget_version_id
718: and (

Line 762: PA_BUDGET_LINES bl ,

758: nvl(b.leaf_node,1) ,
759: nvl(b.wbs_rbs_level,1),
760: '/'||decode(p_fact_slice,'WBS_TO_RBS',ra.rbs_element_id,'WBS_TO_CBS',ra.cbs_element_id,null)
761: FROM PA_RESOURCE_ASSIGNMENTS ra ,
762: PA_BUDGET_LINES bl ,
763: pa_ppr_obj_tmp b,
764: pa_ppr_obj_tmp2 c
765: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
766: and ra.budget_version_id = l_budget_version_id

Line 811: PA_BUDGET_LINES bl ,

807: nvl(b.connect_path , '/'||DECODE(ra.task_id, 0, l_struct_elem_id, ra.task_id) ) ,
808: nvl(b.leaf_node,1) ,
809: nvl(b.wbs_rbs_level,1)
810: FROM PA_RESOURCE_ASSIGNMENTS ra ,
811: PA_BUDGET_LINES bl ,
812: pa_ppr_obj_tmp b,
813: pa_ppr_obj_tmp2 c
814: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
815: and ra.budget_version_id = l_budget_version_id

Line 856: PA_BUDGET_LINES bl ,

852: nvl(b.connect_path , '/'||DECODE(ra.task_id, 0, l_struct_elem_id, ra.task_id) ) ,
853: nvl(b.leaf_node,1) ,
854: nvl(b.wbs_rbs_level,1)
855: FROM PA_RESOURCE_ASSIGNMENTS ra ,
856: PA_BUDGET_LINES bl ,
857: pa_ppr_obj_tmp b,
858: pa_ppr_obj_tmp2 c
859: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
860: and ra.budget_version_id = l_budget_version_id

Line 958: PA_BUDGET_LINES bl

954: , TO_NUMBER(NULL) quantity
955: , bl.init_quantity act_quantity -- new
956: , TO_NUMBER(NULL) etc_quantity -- new
957: FROM PA_RESOURCE_ASSIGNMENTS ra ,
958: PA_BUDGET_LINES bl
959: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
960: and ra.budget_version_id = l_budget_version_id
961: ) t , pa_ppr_obj_tmp b
962: WHERE t.task_id = b.object_id (+)