699: l_project_id NUMBER;
700: --
701: CURSOR project_id_csr(p_project_id IN NUMBER, p_distribution_date IN DATE) IS
702: SELECT project_id
703: FROM pa_projects_all
704: WHERE project_id = p_project_id
705: AND p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));
706: BEGIN
707: --
1028: AND enabled_flag ='Y';
1029:
1030: CURSOR project_csr(p_project_id IN NUMBER, p_distribution_date IN DATE) IS
1031: SELECT project_id
1032: FROM pa_projects_all
1033: WHERE project_id = p_project_id
1034: AND p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));
1035:
1036: CURSOR task_csr(p_task_id IN NUMBER, p_distribution_date IN DATE) IS