eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_VLP_BUS dependencies on HR_GENERAL

Line 237: nvl(p_rec.start_date, hr_general.start_of_time)

233: -- p_rec.start_date
234: select count(*) into cnt from pqh_fr_validation_periods
235: where previous_employer_id = p_rec.previous_employer_id
236: and
237: nvl(p_rec.start_date, hr_general.start_of_time)
238: between
239: nvl(start_date, hr_general.start_of_time)
240: and
241: nvl(end_date, hr_general.end_of_time);

Line 239: nvl(start_date, hr_general.start_of_time)

235: where previous_employer_id = p_rec.previous_employer_id
236: and
237: nvl(p_rec.start_date, hr_general.start_of_time)
238: between
239: nvl(start_date, hr_general.start_of_time)
240: and
241: nvl(end_date, hr_general.end_of_time);
242:
243: if cnt > 0 then

Line 241: nvl(end_date, hr_general.end_of_time);

237: nvl(p_rec.start_date, hr_general.start_of_time)
238: between
239: nvl(start_date, hr_general.start_of_time)
240: and
241: nvl(end_date, hr_general.end_of_time);
242:
243: if cnt > 0 then
244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
245: fnd_message.raise_error;

Line 251: nvl(p_rec.end_date, hr_general.end_of_time)

247: -- for p_rec.end_date
248: select count(*) into cnt from pqh_fr_validation_periods
249: where previous_employer_id = p_rec.previous_employer_id
250: and
251: nvl(p_rec.end_date, hr_general.end_of_time)
252: between
253: nvl(start_date, hr_general.start_of_time)
254: and
255: nvl(end_date, hr_general.end_of_time);

Line 253: nvl(start_date, hr_general.start_of_time)

249: where previous_employer_id = p_rec.previous_employer_id
250: and
251: nvl(p_rec.end_date, hr_general.end_of_time)
252: between
253: nvl(start_date, hr_general.start_of_time)
254: and
255: nvl(end_date, hr_general.end_of_time);
256:
257: if cnt > 0 then

Line 255: nvl(end_date, hr_general.end_of_time);

251: nvl(p_rec.end_date, hr_general.end_of_time)
252: between
253: nvl(start_date, hr_general.start_of_time)
254: and
255: nvl(end_date, hr_general.end_of_time);
256:
257: if cnt > 0 then
258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
259: fnd_message.raise_error;

Line 265: nvl(start_date, hr_general.start_of_time)

261: --for start_date
262: select count(*) into cnt from pqh_fr_validation_periods
263: where previous_employer_id = p_rec.previous_employer_id
264: and
265: nvl(start_date, hr_general.start_of_time)
266: between
267: nvl(p_rec.start_date, hr_general.start_of_time)
268: and
269: nvl(p_rec.end_date, hr_general.end_of_time);

Line 267: nvl(p_rec.start_date, hr_general.start_of_time)

263: where previous_employer_id = p_rec.previous_employer_id
264: and
265: nvl(start_date, hr_general.start_of_time)
266: between
267: nvl(p_rec.start_date, hr_general.start_of_time)
268: and
269: nvl(p_rec.end_date, hr_general.end_of_time);
270:
271: if cnt > 0 then

Line 269: nvl(p_rec.end_date, hr_general.end_of_time);

265: nvl(start_date, hr_general.start_of_time)
266: between
267: nvl(p_rec.start_date, hr_general.start_of_time)
268: and
269: nvl(p_rec.end_date, hr_general.end_of_time);
270:
271: if cnt > 0 then
272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
273: fnd_message.raise_error;

Line 279: nvl(end_date, hr_general.end_of_time)

275: -- for end_date
276: select count(*) into cnt from pqh_fr_validation_periods
277: where previous_employer_id = p_rec.previous_employer_id
278: and
279: nvl(end_date, hr_general.end_of_time)
280: between
281: nvl(p_rec.start_date, hr_general.start_of_time)
282: and
283: nvl(p_rec.end_date, hr_general.end_of_time);

Line 281: nvl(p_rec.start_date, hr_general.start_of_time)

277: where previous_employer_id = p_rec.previous_employer_id
278: and
279: nvl(end_date, hr_general.end_of_time)
280: between
281: nvl(p_rec.start_date, hr_general.start_of_time)
282: and
283: nvl(p_rec.end_date, hr_general.end_of_time);
284:
285: if cnt > 0 then

Line 283: nvl(p_rec.end_date, hr_general.end_of_time);

279: nvl(end_date, hr_general.end_of_time)
280: between
281: nvl(p_rec.start_date, hr_general.start_of_time)
282: and
283: nvl(p_rec.end_date, hr_general.end_of_time);
284:
285: if cnt > 0 then
286: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
287: fnd_message.raise_error;

Line 328: nvl(p_rec.start_date, hr_general.start_of_time)

324: select count(*) into cnt from pqh_fr_validation_periods
325: where previous_employer_id = p_rec.previous_employer_id
326: and validation_period_id <> p_rec.validation_period_id
327: and
328: nvl(p_rec.start_date, hr_general.start_of_time)
329: between
330: nvl(start_date, hr_general.start_of_time)
331: and
332: nvl(end_date, hr_general.end_of_time);

Line 330: nvl(start_date, hr_general.start_of_time)

326: and validation_period_id <> p_rec.validation_period_id
327: and
328: nvl(p_rec.start_date, hr_general.start_of_time)
329: between
330: nvl(start_date, hr_general.start_of_time)
331: and
332: nvl(end_date, hr_general.end_of_time);
333:
334: if cnt > 0 then

Line 332: nvl(end_date, hr_general.end_of_time);

328: nvl(p_rec.start_date, hr_general.start_of_time)
329: between
330: nvl(start_date, hr_general.start_of_time)
331: and
332: nvl(end_date, hr_general.end_of_time);
333:
334: if cnt > 0 then
335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
336: fnd_message.raise_error;

Line 343: nvl(p_rec.end_date, hr_general.end_of_time)

339: select count(*) into cnt from pqh_fr_validation_periods
340: where previous_employer_id = p_rec.previous_employer_id
341: and validation_period_id <> p_rec.validation_period_id
342: and
343: nvl(p_rec.end_date, hr_general.end_of_time)
344: between
345: nvl(start_date, hr_general.start_of_time)
346: and
347: nvl(end_date, hr_general.end_of_time);

Line 345: nvl(start_date, hr_general.start_of_time)

341: and validation_period_id <> p_rec.validation_period_id
342: and
343: nvl(p_rec.end_date, hr_general.end_of_time)
344: between
345: nvl(start_date, hr_general.start_of_time)
346: and
347: nvl(end_date, hr_general.end_of_time);
348:
349: if cnt > 0 then

Line 347: nvl(end_date, hr_general.end_of_time);

343: nvl(p_rec.end_date, hr_general.end_of_time)
344: between
345: nvl(start_date, hr_general.start_of_time)
346: and
347: nvl(end_date, hr_general.end_of_time);
348:
349: if cnt > 0 then
350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
351: fnd_message.raise_error;

Line 358: nvl(start_date, hr_general.start_of_time)

354: select count(*) into cnt from pqh_fr_validation_periods
355: where previous_employer_id = p_rec.previous_employer_id
356: and validation_period_id <> p_rec.validation_period_id
357: and
358: nvl(start_date, hr_general.start_of_time)
359: between
360: nvl(p_rec.start_date, hr_general.start_of_time)
361: and
362: nvl(p_rec.end_date, hr_general.end_of_time);

Line 360: nvl(p_rec.start_date, hr_general.start_of_time)

356: and validation_period_id <> p_rec.validation_period_id
357: and
358: nvl(start_date, hr_general.start_of_time)
359: between
360: nvl(p_rec.start_date, hr_general.start_of_time)
361: and
362: nvl(p_rec.end_date, hr_general.end_of_time);
363:
364: if cnt > 0 then

Line 362: nvl(p_rec.end_date, hr_general.end_of_time);

358: nvl(start_date, hr_general.start_of_time)
359: between
360: nvl(p_rec.start_date, hr_general.start_of_time)
361: and
362: nvl(p_rec.end_date, hr_general.end_of_time);
363:
364: if cnt > 0 then
365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
366: fnd_message.raise_error;

Line 373: nvl(end_date, hr_general.end_of_time)

369: select count(*) into cnt from pqh_fr_validation_periods
370: where previous_employer_id = p_rec.previous_employer_id
371: and validation_period_id <> p_rec.validation_period_id
372: and
373: nvl(end_date, hr_general.end_of_time)
374: between
375: nvl(p_rec.start_date, hr_general.start_of_time)
376: and
377: nvl(p_rec.end_date, hr_general.end_of_time);

Line 375: nvl(p_rec.start_date, hr_general.start_of_time)

371: and validation_period_id <> p_rec.validation_period_id
372: and
373: nvl(end_date, hr_general.end_of_time)
374: between
375: nvl(p_rec.start_date, hr_general.start_of_time)
376: and
377: nvl(p_rec.end_date, hr_general.end_of_time);
378:
379: if cnt > 0 then

Line 377: nvl(p_rec.end_date, hr_general.end_of_time);

373: nvl(end_date, hr_general.end_of_time)
374: between
375: nvl(p_rec.start_date, hr_general.start_of_time)
376: and
377: nvl(p_rec.end_date, hr_general.end_of_time);
378:
379: if cnt > 0 then
380: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
381: fnd_message.raise_error;