APPS.PA_PAY_UTIL dependencies on PA_WORK_TYPES_VL

Line 132: l_work_type_name pa_work_types_vl.name%TYPE;

128: FUNCTION get_work_type(p_assignment_id NUMBER,
129: p_earned_date DATE)
130: return varchar2 IS
131:
132: l_work_type_name pa_work_types_vl.name%TYPE;
133:
134: begin
135: if pa_pay_util.g_expenditure_item_id is not null then
136: select name

Line 138: from pa_work_types_vl

134: begin
135: if pa_pay_util.g_expenditure_item_id is not null then
136: select name
137: into l_work_type_name
138: from pa_work_types_vl
139: where work_type_id = (select work_type_id
140: from pa_expenditure_items_all
141: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
142: