APPS.PA_HR_TRANSACTIONS dependencies on PA_EI_DENORM

Line 49: from PA_EI_DENORM pa

45:
46: /* Commented for Bug#3211124
47: cursor ei_denorm( p_person_id number ) is
48: select null
49: from PA_EI_DENORM pa
50: where pa.person_id = P_PERSON_ID;
51: * Commented code for Bug#3211124 ends here */
52:
53: cursor expenditure( p_person_id number ) is

Line 203: from pa_ei_denorm pa

199:
200: /* Commented for Bug#3211124
201: cursor ei_denorm( p_job_id varchar ) is
202: select null
203: from pa_ei_denorm pa
204: where (pa.job_id_1 is not null
205: AND pa.job_id_1 = P_JOB_ID )
206: OR (pa.job_id_2 is not null
207: AND pa.job_id_2 = P_JOB_ID )

Line 236: from pa_ei_denorm

232: expenditure_item_date_5, quantity_5,
233: expenditure_item_date_6, quantity_6,
234: expenditure_item_date_7, quantity_7,
235: person_id
236: from pa_ei_denorm
237: where expenditure_id = p_exp_id;
238:
239: BEGIN
240: Error_Message := 'PA_HR_JOB_ONLINE_EXPEND';