DBA Data[Home] [Help]

APPS.PA_PROJ_TSK_UTILS dependencies on AP_INVOICES_ALL

Line 517: FROM ap_invoices_all

513: cursor c1 is
514: SELECT 1
515: FROM sys.dual
516: WHERE EXISTS (SELECT NULL
517: FROM ap_invoices_all
518: WHERE project_id = x_project_id);
519:
520: cursor c2 is
521: SELECT 1

Line 524: FROM ap_invoices_all

520: cursor c2 is
521: SELECT 1
522: FROM sys.dual
523: where exists (SELECT NULL
524: FROM ap_invoices_all
525: where project_id = x_proj_id
526: AND TASK_ID IN
527: (SELECT TASK_ID
528: FROM PA_TASKS

Line 536: FROM ap_invoices_all

532: /* cursor c2 is
533: SELECT 1
534: FROM sys.dual
535: where exists (SELECT NULL
536: FROM ap_invoices_all
537: where project_id = x_proj_id
538: AND TASK_ID IN
539: (SELECT TASK_ID
540: FROM PA_TASKS

Line 551: FROM ap_invoices_all

547: cursor c3 is
548: SELECT 1
549: FROM sys.dual
550: where exists (SELECT NULL
551: FROM ap_invoices_all
552: where project_id = x_proj_id
553: AND TASK_ID = x_task_id);
554: c3_rec c3%rowtype;
555: