APPS.PA_COST_PLUS dependencies on PA_SYSTEM_LINKAGES

Line 5118: pa_system_linkages syslink,

5114: CURSOR ei13_cursor
5115: IS
5116: SELECT expenditure_item_id
5117: FROM pa_expenditure_items_all ei,
5118: pa_system_linkages syslink,
5119: pa_tasks task,
5120: pa_projects_all proj
5121: WHERE ei.tp_ind_compiled_set_id = compiled_set_id
5122: AND ei.system_linkage_function = syslink.function

Line 5149: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */

5145: FROM PA_EXPENDITURE_ITEMS_ALL EI
5146: WHERE tp_ind_compiled_set_id = compiled_set_id
5147: AND EXISTS
5148: (SELECT task_id
5149: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */
5150: WHERE task.task_id = ei.task_id
5151: AND ei.system_linkage_function = syslink.function
5152: /*AND task.project_id = proj.project_id 2933915*/
5153: AND task.project_id = ei.project_id /*2933915*/

Line 5918: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/

5914: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5915: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5916: AND EXISTS
5917: (SELECT task_id
5918: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/
5919: WHERE task.task_id = ei.task_id
5920: AND ei.system_linkage_function = syslink.function
5921: /* AND task.project_id = proj.project_id Commented for 2933915*/
5922: AND task.project_id = ei.project_id /*2933915*/