DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PUB dependencies on PA_PROJECT_DATES_UTILS

Line 720: by calling PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE API*/

716: return DATE
717: IS
718:
719: /* Bug 2636791 - We will be selecting start date
720: by calling PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE API*/
721: /*
722: CURSOR date_csr IS
723: SELECT start_date from pa_projects_all
724: WHERE project_id = p_project_id;

Line 738: l_project_start_date := PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id);

734: CLOSE date_csr;
735: */
736:
737:
738: l_project_start_date := PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id);
739:
740: if l_project_start_date is not NULL then
741: if l_project_start_date <= trunc(sysdate) then
742: return l_project_start_date;