APPS.PA_HR_TRANSACTIONS dependencies on PA_UTILS

Line 237: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_1) = P_JOB_ID then

233:
234: for oit_exp_rec in oit_expenditures loop
235: for ei_denorm_rec in ei_denorm(oit_exp_rec.expenditure_id) loop
236: if (ei_denorm_rec.quantity_1 is not null) then
237: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_1) = P_JOB_ID then
238: raise reference_exists;
239: end if;
240: end if;
241: if (ei_denorm_rec.quantity_2 is not null) then

Line 242: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_2) = P_JOB_ID then

238: raise reference_exists;
239: end if;
240: end if;
241: if (ei_denorm_rec.quantity_2 is not null) then
242: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_2) = P_JOB_ID then
243: raise reference_exists;
244: end if;
245: end if;
246: if (ei_denorm_rec.quantity_3 is not null) then

Line 247: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_3) = P_JOB_ID then

243: raise reference_exists;
244: end if;
245: end if;
246: if (ei_denorm_rec.quantity_3 is not null) then
247: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_3) = P_JOB_ID then
248: raise reference_exists;
249: end if;
250: end if;
251: if (ei_denorm_rec.quantity_4 is not null) then

Line 252: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_4) = P_JOB_ID then

248: raise reference_exists;
249: end if;
250: end if;
251: if (ei_denorm_rec.quantity_4 is not null) then
252: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_4) = P_JOB_ID then
253: raise reference_exists;
254: end if;
255: end if;
256: if (ei_denorm_rec.quantity_5 is not null) then

Line 257: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_5) = P_JOB_ID then

253: raise reference_exists;
254: end if;
255: end if;
256: if (ei_denorm_rec.quantity_5 is not null) then
257: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_5) = P_JOB_ID then
258: raise reference_exists;
259: end if;
260: end if;
261: if (ei_denorm_rec.quantity_6 is not null) then

Line 262: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_6) = P_JOB_ID then

258: raise reference_exists;
259: end if;
260: end if;
261: if (ei_denorm_rec.quantity_6 is not null) then
262: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_6) = P_JOB_ID then
263: raise reference_exists;
264: end if;
265: end if;
266: if (ei_denorm_rec.quantity_7 is not null) then

Line 267: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_7) = P_JOB_ID then

263: raise reference_exists;
264: end if;
265: end if;
266: if (ei_denorm_rec.quantity_7 is not null) then
267: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_7) = P_JOB_ID then
268: raise reference_exists;
269: end if;
270: end if;
271: end loop;