APPS.PA_PROJECT_PARTIES_UTILS dependencies on DUAL

Line 1045: SELECT 'y' FROM dual WHERE start_date_active > l_proj_end_date

1041: where project_id = p_project_id
1042: and project_role_type='PROJECT MANAGER'
1043: AND NOT (
1044: exists(
1045: SELECT 'y' FROM dual WHERE start_date_active > l_proj_end_date
1046: )
1047: OR
1048: exists(
1049: SELECT 'y' FROM dual WHERE end_date_active < l_proj_start_date

Line 1049: SELECT 'y' FROM dual WHERE end_date_active < l_proj_start_date

1045: SELECT 'y' FROM dual WHERE start_date_active > l_proj_end_date
1046: )
1047: OR
1048: exists(
1049: SELECT 'y' FROM dual WHERE end_date_active < l_proj_start_date
1050: )
1051: )
1052: order by start_date_active;
1053:

Line 1063: SELECT 'y' FROM dual WHERE start_date_active > l_proj_end_date

1059: where project_id = p_project_id
1060: and project_role_id = 1
1061: AND NOT (
1062: exists(
1063: SELECT 'y' FROM dual WHERE start_date_active > l_proj_end_date
1064: )
1065: OR
1066: exists(
1067: SELECT 'y' FROM dual WHERE end_date_active < l_proj_start_date

Line 1067: SELECT 'y' FROM dual WHERE end_date_active < l_proj_start_date

1063: SELECT 'y' FROM dual WHERE start_date_active > l_proj_end_date
1064: )
1065: OR
1066: exists(
1067: SELECT 'y' FROM dual WHERE end_date_active < l_proj_start_date
1068: )
1069: )
1070: order by start_date_active;
1071: