APPS.PA_PAY_UTIL dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 42: from pa_expenditure_items_all

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:
45: return l_task_number;
46: else

Line 67: from pa_expenditure_items_all

63: select segment1
64: into l_project_number
65: from pa_projects_all
66: where project_id = (select project_id
67: from pa_expenditure_items_all
68: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
69:
70: return l_project_number;
71: else

Line 92: from pa_expenditure_items_all

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;
95: else
96: return pa_pay_util.g_job_name;

Line 116: from pa_expenditure_items_all

112: select location_code
113: into l_location_code
114: from hr_locations
115: where location_id = (select location_id
116: from pa_expenditure_items_all
117: where expenditure_item_id = pa_pay_util.g_expenditure_item_id);
118: return l_location_code;
119: else
120: return pa_pay_util.g_location_code;

Line 140: from pa_expenditure_items_all

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:
143: return l_work_type_name;
144: else