APPS.PAY_ELEMENT_DATA_PUMP dependencies on HR_API

Line 222: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=

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;

Line 223: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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:

Line 257: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =

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);

Line 258: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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:

Line 286: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=

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 ;

Line 287: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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:

Line 319: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =

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) ;

Line 320: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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:

Line 353: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=

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 ;

Line 354: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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:

Line 384: HR_API.RETURN_LEGISLATION_CODE(p_business_group_id)

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))

Line 419: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=

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) ;

Line 420: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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:

Line 448: and (legislation_code = HR_API.RETURN_LEGISLATION_CODE(p_business_group_id)

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))

Line 568: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=

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

Line 569: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')

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