APPS.PA_PROJ_TSK_UTILS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 640: FROM ap_invoice_distributions_all

636: cursor c1 is
637: SELECT 1
638: FROM sys.dual
639: WHERE EXISTS (SELECT NULL
640: FROM ap_invoice_distributions_all
641: WHERE project_id = x_project_id
642: AND nvl(encumbered_flag,'N') = 'Y'); -- Bug 6153950: added encumbered_flag
643:
644: cursor c2 is

Line 648: FROM ap_invoice_distributions_all

644: cursor c2 is
645: SELECT 1
646: FROM sys.dual
647: where exists (SELECT NULL
648: FROM ap_invoice_distributions_all
649: where project_id = x_proj_id
650: AND nvl(encumbered_flag,'N') = 'Y' -- Bug 6153950: added encumbered_flag
651: AND TASK_ID IN
652: (SELECT TASK_ID

Line 661: FROM ap_invoice_distributions_all

657: /* cursor c2 is
658: SELECT 1
659: FROM sys.dual
660: where exists (SELECT NULL
661: FROM ap_invoice_distributions_all
662: where project_id = x_proj_id
663: AND TASK_ID IN
664: (SELECT TASK_ID
665: FROM PA_TASKS

Line 676: FROM ap_invoice_distributions_all

672: cursor c3 is
673: SELECT 1
674: FROM sys.dual
675: where exists (SELECT NULL
676: FROM ap_invoice_distributions_all
677: where project_id = x_proj_id
678: AND TASK_ID = x_TASK_ID);
679: c3_rec c3%rowtype;
680: