DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 812: FROM pa_expenditure_items_all ei, pa_tasks t

808:
809: /* Commented for bug 3088395 */ /* The following SQL statement was uncommented for bug 3872496 */
810: CURSOR EI_BILL_HOLD_CUR IS
811: SELECT ei.expenditure_item_id
812: FROM pa_expenditure_items_all ei, pa_tasks t
813: WHERE ei.bill_hold_flag = 'O'
814: AND ei.task_id = t.task_id
815: AND t.project_id = P_Project_ID;
816:

Line 822: FROM pa_expenditure_items_all ei

818: /* The following SQL statement was commented for bug 3872496 */
819: /*Added for bug 3088395
820: CURSOR EI_BILL_HOLD_CUR IS
821: SELECT ei.expenditure_item_id
822: FROM pa_expenditure_items_all ei
823: WHERE ei.bill_hold_flag = 'O' /*Bill Hold Once
824: AND ei.project_id = P_Project_ID;
825: */
826: