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 PQH_FR_VALIDATION_PERIODS

Line 30: , pqh_fr_validation_periods vlp

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_fr_validation_periods vlp
31: , pqh_fr_validations vld
32: where vld.validation_id = vlp.validation_id
33: and vlp.validation_period_id = p_validation_period_id
34: and pbg.business_group_id = vld.business_group_id;

Line 96: , pqh_fr_validation_periods vlp

92: --
93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: , pqh_fr_validation_periods vlp
97: , pqh_Fr_validations vld
98: where vld.validation_id = vlp.validation_id
99: and vlp.validation_period_id = p_validation_period_id
100: and pbg.business_group_id = vld.business_group_id;

Line 230: select count(*) into cnt from pqh_fr_validation_periods

226: --
227: -- Validate Dependent Attributes
228: --
229: --
230: select count(*) into cnt from pqh_fr_validation_periods
231: where previous_employer_id = p_rec.previous_employer_id;
232: if cnt > 0 then
233: -- p_rec.start_date
234: select count(*) into cnt from pqh_fr_validation_periods

Line 234: select count(*) into cnt from pqh_fr_validation_periods

230: select count(*) into cnt from pqh_fr_validation_periods
231: where previous_employer_id = p_rec.previous_employer_id;
232: if cnt > 0 then
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

Line 248: select count(*) into cnt from pqh_fr_validation_periods

244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
245: fnd_message.raise_error;
246: end if;
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

Line 262: select count(*) into cnt from pqh_fr_validation_periods

258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
259: fnd_message.raise_error;
260: end if;
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

Line 276: select count(*) into cnt from pqh_fr_validation_periods

272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
273: fnd_message.raise_error;
274: end if;
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

Line 319: select count(*) into cnt from pqh_fr_validation_periods

315: (p_effective_date => p_effective_date
316: ,p_rec => p_rec
317: );
318: --
319: select count(*) into cnt from pqh_fr_validation_periods
320: where previous_employer_id = p_rec.previous_employer_id
321: and validation_period_id <> p_rec.validation_period_id;
322: if cnt > 0 then
323: -- p_rec.start_date

Line 324: select count(*) into cnt from pqh_fr_validation_periods

320: where previous_employer_id = p_rec.previous_employer_id
321: and validation_period_id <> p_rec.validation_period_id;
322: if cnt > 0 then
323: -- p_rec.start_date
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)

Line 339: select count(*) into cnt from pqh_fr_validation_periods

335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
336: fnd_message.raise_error;
337: end if;
338: -- for p_rec.end_date
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)

Line 354: select count(*) into cnt from pqh_fr_validation_periods

350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
351: fnd_message.raise_error;
352: end if;
353: --for start_date
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)

Line 369: select count(*) into cnt from pqh_fr_validation_periods

365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
366: fnd_message.raise_error;
367: end if;
368: -- for end_date
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)