APPS.PSP_GENERAL dependencies on PA_TASKS_EXPEND_V

Line 819: FROM pa_tasks -- Bug : 16391366 -- 'pa_tasks_expend_v' view change is not required.

815: WHERE award_id = p_award_id;
816:
817: SELECT nvl(completion_date,p_payroll_end_date)
818: INTO l_completion_date
819: FROM pa_tasks -- Bug : 16391366 -- 'pa_tasks_expend_v' view change is not required.
820: WHERE task_id = p_task_id;
821:
822: SELECT least(p_payroll_end_date,l_project_end_date,l_award_end_date,l_completion_date)
823: INTO l_poeta_effective_date

Line 861: FROM pa_tasks -- Bug : 16391366 -- 'pa_tasks_expend_v' view change is not required.

857:
858:
859: SELECT nvl(completion_date,p_payroll_end_date)
860: INTO l_completion_date
861: FROM pa_tasks -- Bug : 16391366 -- 'pa_tasks_expend_v' view change is not required.
862: WHERE task_id = p_task_id;
863:
864: SELECT least(p_payroll_end_date,l_project_end_date,l_completion_date)
865: INTO l_poeta_effective_date

Line 1388: FROM pa_tasks_expend_v -- Bug : 16391366

1384:
1385: FUNCTION get_task_number (p_task_id IN NUMBER) RETURN VARCHAR2 IS
1386: CURSOR task_number_cur IS
1387: SELECT task_number
1388: FROM pa_tasks_expend_v -- Bug : 16391366
1389: WHERE task_id = p_task_id;
1390:
1391: l_task_number VARCHAR2(300); -- Bug : 16391366 variable size is changed from 200 to 300
1392: