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 1446: from sys.dual where

1442: begin
1443: begin
1444: select 1
1445: into temp
1446: from sys.dual where
1447: exists ( select 1 from pa_options where parent_option_code = p_option_code);
1448: rv := 'Y';
1449: exception
1450: when NO_DATA_FOUND then

Line 1542: from sys.dual

1538:
1539: begin
1540: select null
1541: into dummy
1542: from sys.dual
1543: where not exists (
1544: select null
1545: from pa_expenditure_items_all pai
1546: /* Bug#3461661 : removed join with pa_tasks

Line 1577: from sys.dual

1573:
1574: begin
1575: select null
1576: into dummy
1577: from sys.dual
1578: where not exists (
1579: select null
1580: from pa_draft_revenues_all
1581: where project_id = x_project_id);

Line 1602: from sys.dual

1598:
1599: begin
1600: select null
1601: into dummy
1602: from sys.dual
1603: where not exists (
1604: select null
1605: from pa_draft_invoices_all
1606: where project_id = x_project_id);

Line 1830: FROM dual

1826: return varchar2
1827: IS
1828: CURSOR C_schedule_in_use IS
1829: SELECT '1'
1830: FROM dual
1831: WHERE EXISTS (SELECT 'Y'
1832: FROM PA_PROJECTS_ALL PP
1833: WHERE PP.labor_tp_schedule_id=p_tp_schedule_id
1834: OR PP.nl_tp_schedule_id=p_tp_schedule_id

Line 2096: FROM DUAL

2092: RETURN NUMBER
2093: IS
2094: CURSOR c1 is
2095: SELECT 'Y'
2096: FROM DUAL
2097: WHERE EXISTS (SELECT 'Y'
2098: FROM PA_PROJECT_CUSTOMERS
2099: WHERE project_id = p_project_id
2100: AND (customer_id <> bill_to_customer_id