APPS.PA_PAY_UTIL dependencies on PA_TASKS

Line 33: l_task_number pa_tasks.task_number%TYPE;

29: FUNCTION get_task(p_assignment_id NUMBER,
30: p_earned_date DATE)
31: return varchar2 IS
32:
33: l_task_number pa_tasks.task_number%TYPE;
34:
35: begin
36:
37: if pa_pay_util.g_expenditure_item_id is not null then

Line 40: from pa_tasks

36:
37: if pa_pay_util.g_expenditure_item_id is not null then
38: select task_number
39: into l_task_number
40: from pa_tasks
41: where task_id = (select task_id
42: from pa_expenditure_items_all
43: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
44: