APPS.PA_HR_TRANSACTIONS dependencies on PA_UTILS

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

248:
249: for oit_exp_rec in oit_expenditures loop
250: for ei_denorm_rec in ei_denorm(oit_exp_rec.expenditure_id) loop
251: if (ei_denorm_rec.quantity_1 is not null) then
252: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_1) = P_JOB_ID then
253: raise reference_exists;
254: end if;
255: end if;
256: if (ei_denorm_rec.quantity_2 is not null) then

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

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

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

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

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

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

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

268: raise reference_exists;
269: end if;
270: end if;
271: if (ei_denorm_rec.quantity_5 is not null) then
272: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_5) = P_JOB_ID then
273: raise reference_exists;
274: end if;
275: end if;
276: if (ei_denorm_rec.quantity_6 is not null) then

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

273: raise reference_exists;
274: end if;
275: end if;
276: if (ei_denorm_rec.quantity_6 is not null) then
277: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_6) = P_JOB_ID then
278: raise reference_exists;
279: end if;
280: end if;
281: if (ei_denorm_rec.quantity_7 is not null) then

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

278: raise reference_exists;
279: end if;
280: end if;
281: if (ei_denorm_rec.quantity_7 is not null) then
282: if pa_utils.GetEmpJobId(ei_denorm_rec.person_id, ei_denorm_rec.expenditure_item_date_7) = P_JOB_ID then
283: raise reference_exists;
284: end if;
285: end if;
286: end loop;