APPS.PA_PROJECT_UTILS dependencies on DUAL

Line 477: from sys.dual

473: function check_manager_exists (x_project_id IN number ) return number
474: is
475: cursor c1 is
476: select 1
477: from sys.dual
478: where exists (SELECT person_id
479: FROM pa_project_players
480: WHERE project_id = x_project_id
481: and project_role_type = 'PROJECT MANAGER'

Line 567: from sys.dual

563: function check_bill_contact_exists (x_project_id IN number ) return number
564: is
565: cursor c1 is
566: select 1
567: from sys.dual
568: where exists (SELECT NULL
569: FROM PA_PROJECT_CUSTOMERS CUST
570: WHERE CUST.PROJECT_ID = x_project_id
571: AND CUST.CUSTOMER_BILL_SPLIT > 0

Line 616: from sys.dual

612: function check_class_category (x_project_id IN number ) return number
613: is
614: cursor c1 is
615: select 1
616: from sys.dual
617: where exists (SELECT NULL
618: -- anlee - modified for Classifications enhancements
619: /*
620: FROM PA_CLASS_CATEGORIES CC

Line 680: FROM sys.dual

676: x_proj_id number;
677:
678: cursor c1 is
679: SELECT 1
680: FROM sys.dual
681: WHERE EXISTS (SELECT NULL
682: FROM pa_draft_invoices
683: WHERE project_id = x_project_id);
684:

Line 726: FROM sys.dual

722: x_proj_id number;
723:
724: cursor c1 is
725: SELECT 1
726: FROM sys.dual
727: WHERE EXISTS (SELECT NULL
728: FROM pa_draft_revenues
729: WHERE project_id = x_project_id);
730:

Line 770: from sys.dual

766: function check_created_proj_reference (x_project_id IN number ) return number
767: is
768: cursor c1 is
769: select 1
770: from sys.dual
771: where exists (SELECT null
772: FROM pa_projects
773: where created_from_project_id = x_project_id);
774:

Line 1458: from sys.dual where

1454: begin
1455: begin
1456: select 1
1457: into temp
1458: from sys.dual where
1459: exists ( select 1 from pa_options where parent_option_code = p_option_code);
1460: rv := 'Y';
1461: exception
1462: when NO_DATA_FOUND then

Line 1554: from sys.dual

1550:
1551: begin
1552: select null
1553: into dummy
1554: from sys.dual
1555: where not exists (
1556: select null
1557: from pa_expenditure_items_all pai
1558: /* Bug#3461661 : removed join with pa_tasks

Line 1589: from sys.dual

1585:
1586: begin
1587: select null
1588: into dummy
1589: from sys.dual
1590: where not exists (
1591: select null
1592: from pa_draft_revenues_all
1593: where project_id = x_project_id);

Line 1614: from sys.dual

1610:
1611: begin
1612: select null
1613: into dummy
1614: from sys.dual
1615: where not exists (
1616: select null
1617: from pa_draft_invoices_all
1618: where project_id = x_project_id);

Line 1842: FROM dual

1838: return varchar2
1839: IS
1840: CURSOR C_schedule_in_use IS
1841: SELECT '1'
1842: FROM dual
1843: WHERE EXISTS (SELECT 'Y'
1844: FROM PA_PROJECTS_ALL PP
1845: WHERE PP.labor_tp_schedule_id=p_tp_schedule_id
1846: OR PP.nl_tp_schedule_id=p_tp_schedule_id

Line 2108: FROM DUAL

2104: RETURN NUMBER
2105: IS
2106: CURSOR c1 is
2107: SELECT 'Y'
2108: FROM DUAL
2109: WHERE EXISTS (SELECT 'Y'
2110: FROM PA_PROJECT_CUSTOMERS
2111: WHERE project_id = p_project_id
2112: AND (customer_id <> bill_to_customer_id