DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PERIOD_PVT dependencies on PA_BUDGET_LINES

Line 531: PA_BUDGET_LINES bl ,

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
535: and ra.task_id = b.object_id

Line 576: PA_BUDGET_LINES bl ,

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
580: and (

Line 621: PA_BUDGET_LINES bl ,

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
625: and ra.budget_version_id = l_budget_version_id

Line 666: PA_BUDGET_LINES bl ,

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
670: and ra.budget_version_id = l_budget_version_id

Line 709: PA_BUDGET_LINES bl ,

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
713: and ra.budget_version_id = l_budget_version_id