APPS.PA_PROJECT_PARTIES_UTILS dependencies on DUAL

Line 1048: SELECT 'y' FROM dual WHERE trunc(start_date_active) > trunc(l_proj_end_date)

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

Line 1052: SELECT 'y' FROM dual WHERE trunc(end_date_active) < trunc(l_proj_start_date)

1048: SELECT 'y' FROM dual WHERE trunc(start_date_active) > trunc(l_proj_end_date)
1049: )
1050: OR
1051: exists(
1052: SELECT 'y' FROM dual WHERE trunc(end_date_active) < trunc(l_proj_start_date)
1053: )
1054: )
1055: order by start_date_active;
1056:

Line 1066: SELECT 'y' FROM dual WHERE trunc(start_date_active) > trunc(l_proj_end_date)

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

Line 1070: SELECT 'y' FROM dual WHERE trunc(end_date_active) < trunc(l_proj_start_date)

1066: SELECT 'y' FROM dual WHERE trunc(start_date_active) > trunc(l_proj_end_date)
1067: )
1068: OR
1069: exists(
1070: SELECT 'y' FROM dual WHERE trunc(end_date_active) < trunc(l_proj_start_date)
1071: )
1072: )
1073: order by start_date_active;
1074: