APPS.PA_PROGRESS_PVT dependencies on PA_TASK_ASGMTS_V

Line 1050: pa_task_asgmts_v asgn,

1046: nvl(asgn.planned_bur_cost_proj_cur,0)
1047: ))
1048: ) bac_value_in_task_deriv
1049: FROM
1050: pa_task_asgmts_v asgn,
1051: pa_progress_rollup ppr
1052: WHERE asgn.task_version_id = c_task_ver_id
1053: AND asgn.project_id = ppr.project_id
1054: AND asgn.RESOURCE_LIST_MEMBER_ID = ppr.object_id -- Bug 3764224

Line 1157: pa_task_asgmts_v asgn

1153: , decode(c_task_per_comp_deriv_method,'EFFORT',decode(asgn.rate_based_flag,'Y',
1154: decode(asgn.resource_class_code,'PEOPLE', asgn.planned_quantity, 'EQUIPMENT', asgn.planned_quantity, 0),0)
1155: ,asgn.planned_bur_cost_proj_cur) bac_value_in_task_deriv --3801780
1156: FROM
1157: pa_task_asgmts_v asgn
1158: WHERE asgn.task_version_id = c_task_ver_id
1159: AND pa_progress_utils.get_max_rollup_asofdate(asgn.project_id,
1160: 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
1161: IS NULL

Line 6373: pa_task_asgmts_v asgn,

6369: ) bac_value_in_task_deriv
6370: , ppr.Oth_quantity_to_date
6371: , ppr.Oth_etc_quantity
6372: FROM
6373: pa_task_asgmts_v asgn,
6374: pa_progress_rollup ppr
6375: WHERE asgn.task_version_id = c_task_ver_id
6376: AND asgn.task_id = c_task_id
6377: AND asgn.project_id = p_project_id