DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on PA_TASKS

Line 5073: l_task_name pa_tasks.task_name%type;

5069:
5070: FUNCTION GET_TASK_NAME (p_wc_id IN NUMBER)
5071: RETURN VARCHAR2 IS
5072: l_count number;
5073: l_task_name pa_tasks.task_name%type;
5074: begin
5075:
5076: select count(*)
5077: into l_count

Line 5078: from pa_tasks pa,

5074: begin
5075:
5076: select count(*)
5077: into l_count
5078: from pa_tasks pa,
5079: po_distributions_all pod
5080: where pod.task_id = pa.task_id and
5081: pod.po_distribution_id = p_wc_id;
5082:

Line 5090: from pa_tasks pa,

5086: else
5087:
5088: select pa.task_name
5089: into l_task_name
5090: from pa_tasks pa,
5091: po_distributions_all pod
5092: where pod.task_id = pa.task_id and
5093: pod.po_distribution_id = p_wc_id;
5094: