DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 81: FROM gms_encumbrance_items_all Enc1,

77: SELECT 'Y' INTO v_tmp
78: FROM DUAL
79: WHERE EXISTS (
80: SELECT enc1.encumbrance_item_id
81: FROM gms_encumbrance_items_all Enc1,
82: pa_tasks T
83: WHERE enc1.task_id = T.task_id
84: AND T.project_id = p_ProjectID
85: AND enc1.enc_distributed_flag = 'Y'