APPS.PA_PAY_UTIL dependencies on PER_JOBS_V

Line 84: l_job_name per_jobs_v.name%TYPE;

80: FUNCTION get_job(p_assignment_id NUMBER,
81: p_earned_date DATE)
82: return varchar2 IS
83:
84: l_job_name per_jobs_v.name%TYPE;
85:
86: begin
87: if pa_pay_util.g_expenditure_item_id is not null then
88: select name

Line 90: from per_jobs_v

86: begin
87: if pa_pay_util.g_expenditure_item_id is not null then
88: select name
89: into l_job_name
90: from per_jobs_v
91: where job_id = (select job_id
92: from pa_expenditure_items_all
93: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
94: return l_job_name;