DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PUB dependencies on PA_PROJECT_DATES_UTILS

Line 740: by calling PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE API*/

736: return DATE
737: IS
738:
739: /* Bug 2636791 - We will be selecting start date
740: by calling PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE API*/
741: /*
742: CURSOR date_csr IS
743: SELECT start_date from pa_projects_all
744: WHERE project_id = p_project_id;

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

754: CLOSE date_csr;
755: */
756:
757:
758: l_project_start_date := PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id);
759:
760: if l_project_start_date is not NULL then
761: if l_project_start_date <= trunc(sysdate) then
762: return l_project_start_date;