DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PERIOD_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 530: FROM PA_RESOURCE_ASSIGNMENTS ra ,

526: sum(decode( l_version_type,'FINANCIAL', nvl(bl.quantity,0) - nvl(bl.init_quantity,0), 0)) etc_quantity ,
527: '/'||to_number(to_char(bl.start_date,'YYYYMMDD')) ,
528: 1 ,
529: 1 wbs_level
530: FROM PA_RESOURCE_ASSIGNMENTS ra ,
531: PA_BUDGET_LINES bl ,
532: pa_ppr_obj_tmp b
533: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
534: and ra.budget_version_id = l_budget_version_id

Line 575: FROM PA_RESOURCE_ASSIGNMENTS ra ,

571: sum(decode( l_version_type,'FINANCIAL', nvl(bl.quantity,0) - nvl(bl.init_quantity,0), 0)) etc_quantity ,
572: '/'||to_number(to_char(bl.start_date,'YYYYMMDD')) ,
573: 1 ,
574: 1 wbs_level
575: FROM PA_RESOURCE_ASSIGNMENTS ra ,
576: PA_BUDGET_LINES bl ,
577: pa_ppr_obj_tmp b
578: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
579: and ra.budget_version_id = l_budget_version_id

Line 620: FROM PA_RESOURCE_ASSIGNMENTS ra ,

616: sum(nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) etc_quantity ,
617: '/'||to_number(to_char(bl.start_date,'YYYYMMDD')) ,
618: 1 ,
619: 1 wbs_level
620: FROM PA_RESOURCE_ASSIGNMENTS ra ,
621: PA_BUDGET_LINES bl ,
622: pa_ppr_obj_tmp c,
623: pa_ppr_obj_tmp2 b
624: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 665: FROM PA_RESOURCE_ASSIGNMENTS ra ,

661: sum(nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) etc_quantity ,
662: '/'||to_number(to_char(bl.start_date,'YYYYMMDD')) ,
663: 1 ,
664: 1 wbs_level
665: FROM PA_RESOURCE_ASSIGNMENTS ra ,
666: PA_BUDGET_LINES bl ,
667: pa_ppr_obj_tmp c,
668: pa_ppr_obj_tmp2 b
669: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 708: FROM PA_RESOURCE_ASSIGNMENTS ra ,

704: sum(nvl(bl.quantity,0) - nvl(bl.init_quantity,0)) etc_quantity ,
705: '/'||to_number(to_char(bl.start_date,'YYYYMMDD')) ,
706: 1 ,
707: 1 wbs_level
708: FROM PA_RESOURCE_ASSIGNMENTS ra ,
709: PA_BUDGET_LINES bl ,
710: pa_ppr_obj_tmp c,
711: pa_ppr_obj_tmp2 b
712: WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id