218: Where pay.classification_id = paytl.classification_id
219: and paytl.language = userenv('LANG')
220: and pay.parent_classification_id is null
221: and nvl(pay.legislation_code,
222: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
223: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
224: and nvl(pay.business_group_id,nvl(p_business_group_id,-1)) =
225: nvl(p_business_group_id,-1)
226: and paytl.classification_name = p_classification_name;
219: and paytl.language = userenv('LANG')
220: and pay.parent_classification_id is null
221: and nvl(pay.legislation_code,
222: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
223: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
224: and nvl(pay.business_group_id,nvl(p_business_group_id,-1)) =
225: nvl(p_business_group_id,-1)
226: and paytl.classification_name = p_classification_name;
227:
253: and f2.formula_type_name = 'Element Skip'
254: and p_effective_date between f1.effective_start_date and
255: f1.effective_end_date
256: and nvl(legislation_code,
257: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
258: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
259: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
260: nvl(p_business_group_id,-1)
261: and upper(formula_name) = upper(p_formula_Name);
254: and p_effective_date between f1.effective_start_date and
255: f1.effective_end_date
256: and nvl(legislation_code,
257: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
258: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
259: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
260: nvl(p_business_group_id,-1)
261: and upper(formula_name) = upper(p_formula_Name);
262:
282: Select benefit_classification_id
283: INTO l_benefit_classification_id
284: From ben_benefit_classifications
285: Where nvl(legislation_code,
286: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
287: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
288: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
289: nvl(p_business_group_id,-1)
290: and benefit_classification_name = p_benefit_classification_name ;
283: INTO l_benefit_classification_id
284: From ben_benefit_classifications
285: Where nvl(legislation_code,
286: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
287: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
288: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
289: nvl(p_business_group_id,-1)
290: and benefit_classification_name = p_benefit_classification_name ;
291:
315: and f2.formula_type_name = 'Net to Gross'
316: and p_effective_date between f1.effective_start_date and
317: f1.effective_end_date
318: and nvl(legislation_code,
319: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
320: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
321: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
322: nvl(p_business_group_id,-1)
323: and upper(formula_name) = upper(p_iterative_formula_name) ;
316: and p_effective_date between f1.effective_start_date and
317: f1.effective_end_date
318: and nvl(legislation_code,
319: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
320: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
321: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
322: nvl(p_business_group_id,-1)
323: and upper(formula_name) = upper(p_iterative_formula_name) ;
324:
349: Where ec.classification_id = et.classification_id
350: and p_effective_date between et.effective_start_date and
351: et.effective_end_date
352: and nvl(et.legislation_code,
353: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
354: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
355: and nvl(et.business_group_id, nvl(p_business_group_id,-1)) =
356: nvl(p_business_group_id,-1)
357: and et.element_name = p_retro_summ_element_name ;
350: and p_effective_date between et.effective_start_date and
351: et.effective_end_date
352: and nvl(et.legislation_code,
353: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
354: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
355: and nvl(et.business_group_id, nvl(p_business_group_id,-1)) =
356: nvl(p_business_group_id,-1)
357: and et.element_name = p_retro_summ_element_name ;
358:
380: INTO l_event_group_id
381: From pay_event_groups peg
382: Where peg.event_group_type = 'P'
383: and (peg.legislation_code =
384: HR_API.RETURN_LEGISLATION_CODE(p_business_group_id)
385: or ( peg.legislation_code is null and
386: peg.business_group_id = p_business_group_id)
387: or ( peg.legislation_code is null and
388: peg.business_group_id is null))
415: and f2.formula_type_name = 'Payroll Run Proration'
416: and p_effective_date between f1.effective_start_date and
417: f1.effective_end_date
418: and nvl(legislation_code,
419: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
420: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
421: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
422: nvl(p_business_group_id,-1)
423: and upper(formula_name) = upper(p_proration_formula_Name) ;
416: and p_effective_date between f1.effective_start_date and
417: f1.effective_end_date
418: and nvl(legislation_code,
419: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
420: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
421: and nvl(business_group_id,nvl(p_business_group_id,-1)) =
422: nvl(p_business_group_id,-1)
423: and upper(formula_name) = upper(p_proration_formula_Name) ;
424:
444: Select event_group_id
445: INTO l_event_group_id
446: From pay_event_groups
447: Where event_group_type = 'R'
448: and (legislation_code = HR_API.RETURN_LEGISLATION_CODE(p_business_group_id)
449: or ( legislation_code is null and
450: business_group_id = p_business_group_id)
451: or ( legislation_code is null and
452: business_group_id is null))
564: INTO l_formula_id
565: From ff_formulas_f ff,
566: ff_formula_types ft
567: Where nvl(ff.legislation_code,
568: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
569: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
570: and nvl(ff.business_group_id, nvl(p_business_group_id,-1)) =
571: nvl(p_business_group_id,-1)
572: and p_effective_date between ff.effective_start_date and
565: From ff_formulas_f ff,
566: ff_formula_types ft
567: Where nvl(ff.legislation_code,
568: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
569: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
570: and nvl(ff.business_group_id, nvl(p_business_group_id,-1)) =
571: nvl(p_business_group_id,-1)
572: and p_effective_date between ff.effective_start_date and
573: ff.effective_end_date