APPS.PSP_PEE_BUS dependencies on PA_TASKS

Line 753: FROM pa_tasks

749: l_task_id NUMBER;
750: --
751: CURSOR task_id_csr(p_task_id IN NUMBER, p_distribution_date IN DATE) IS
752: SELECT task_id
753: FROM pa_tasks
754: WHERE task_id = p_task_id
755: AND p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));
756: BEGIN
757: --

Line 1038: FROM pa_tasks

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
1037: SELECT task_id
1038: FROM pa_tasks
1039: WHERE task_id = p_task_id
1040: AND p_distribution_date between nvl(start_date,trunc(p_distribution_date)) and nvl(completion_date,to_date('31/12/4712','DD/MM/RRRR'));
1041:
1042: CURSOR award_csr(p_award_id IN NUMBER, p_distribution_date IN DATE) IS