APPS.POS_WCAPPROVE_PVT dependencies on PA_TASKS_EXPEND_V

Line 5400: l_task_name pa_tasks_expend_v.task_name%type;

5396:
5397: FUNCTION GET_TASK_NAME (p_wc_id IN NUMBER)
5398: RETURN VARCHAR2 IS
5399: l_count number;
5400: l_task_name pa_tasks_expend_v.task_name%type;
5401: begin
5402:
5403: select count(*)
5404: into l_count

Line 5405: from pa_tasks_expend_v pa,

5401: begin
5402:
5403: select count(*)
5404: into l_count
5405: from pa_tasks_expend_v pa,
5406: po_distributions_all pod
5407: where pod.task_id = pa.task_id and
5408: pod.po_distribution_id = p_wc_id;
5409:

Line 5417: from pa_tasks_expend_v pa,

5413: else
5414:
5415: select pa.task_name
5416: into l_task_name
5417: from pa_tasks_expend_v pa,
5418: po_distributions_all pod
5419: where pod.task_id = pa.task_id and
5420: pod.po_distribution_id = p_wc_id;
5421: