APPS.PA_PROGRESS_PVT dependencies on PA_TASK_ASGMTS_V

Line 1055: pa_task_asgmts_v asgn,

1051: nvl(asgn.planned_bur_cost_proj_cur,0)
1052: ))
1053: ) bac_value_in_task_deriv
1054: FROM
1055: pa_task_asgmts_v asgn,
1056: pa_progress_rollup ppr
1057: WHERE asgn.task_version_id = c_task_ver_id
1058: AND asgn.project_id = ppr.project_id
1059: AND asgn.RESOURCE_LIST_MEMBER_ID = ppr.object_id -- Bug 3764224

Line 1162: pa_task_asgmts_v asgn

1158: , decode(c_task_per_comp_deriv_method,'EFFORT',decode(asgn.rate_based_flag,'Y',
1159: decode(asgn.resource_class_code,'PEOPLE', asgn.planned_quantity, 'EQUIPMENT', asgn.planned_quantity, 0),0)
1160: ,asgn.planned_bur_cost_proj_cur) bac_value_in_task_deriv --3801780
1161: FROM
1162: pa_task_asgmts_v asgn
1163: WHERE asgn.task_version_id = c_task_ver_id
1164: AND pa_progress_utils.get_max_rollup_asofdate(asgn.project_id,
1165: asgn.RESOURCE_LIST_MEMBER_ID, 'PA_ASSIGNMENTS',p_as_of_date,asgn.task_version_id, p_structure_type, l_structure_version_id, asgn.task_id ) --- Bug 3764224
1166: IS NULL

Line 6439: pa_task_asgmts_v asgn,

6435: ) bac_value_in_task_deriv
6436: , ppr.Oth_quantity_to_date
6437: , ppr.Oth_etc_quantity
6438: FROM
6439: pa_task_asgmts_v asgn,
6440: pa_progress_rollup ppr
6441: WHERE asgn.task_version_id = c_task_ver_id
6442: AND asgn.task_id = c_task_id
6443: AND asgn.project_id = p_project_id