DBA Data[Home] [Help]

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 188: from pa_ei_denorm pa

184:
185: /* Commented for Bug#3211124
186: cursor ei_denorm( p_job_id varchar ) is
187: select null
188: from pa_ei_denorm pa
189: where (pa.job_id_1 is not null
190: AND pa.job_id_1 = P_JOB_ID )
191: OR (pa.job_id_2 is not null
192: AND pa.job_id_2 = P_JOB_ID )

Line 221: from pa_ei_denorm

217: expenditure_item_date_5, quantity_5,
218: expenditure_item_date_6, quantity_6,
219: expenditure_item_date_7, quantity_7,
220: person_id
221: from pa_ei_denorm
222: where expenditure_id = p_exp_id;
223:
224: BEGIN
225: Error_Message := 'PA_HR_JOB_ONLINE_EXPEND';