APPS.PA_COST_PLUS dependencies on PA_SYSTEM_LINKAGES

Line 5148: pa_system_linkages syslink,

5144: CURSOR ei13_cursor
5145: IS
5146: SELECT expenditure_item_id
5147: FROM pa_expenditure_items_all ei,
5148: pa_system_linkages syslink,
5149: pa_tasks task,
5150: pa_projects_all proj
5151: WHERE ei.tp_ind_compiled_set_id = compiled_set_id
5152: AND ei.system_linkage_function = syslink.function

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

5175: FROM PA_EXPENDITURE_ITEMS_ALL EI
5176: WHERE tp_ind_compiled_set_id = compiled_set_id
5177: AND EXISTS
5178: (SELECT task_id
5179: FROM pa_tasks task, pa_system_linkages syslink /*2933915 : ,pa_projects_all proj :Join with pa_projects is not required here */
5180: WHERE task.task_id = ei.task_id
5181: AND ei.system_linkage_function = syslink.function
5182: /*AND task.project_id = proj.project_id 2933915*/
5183: AND task.project_id = ei.project_id /*2933915*/

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

5985: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5986: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5987: AND EXISTS
5988: (SELECT task_id
5989: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/
5990: WHERE task.task_id = ei.task_id
5991: AND ei.system_linkage_function = syslink.function
5992: /* AND task.project_id = proj.project_id Commented for 2933915*/
5993: AND task.project_id = ei.project_id /*2933915*/