DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_CORE_DATES

Line 19: p_payroll_id and p_assact_id to pay_core_dates.is_date_in_span()

15: MODIFIED (DD-MON-YYYY)
16: panumala 21-SEP-2012 Bug 14582716 The changes made through bug 9881366 are
17: proved to be wrong. Reverted these changes.
18: vpallapo 16-JAN-2012 Bug 13537723 Changed get_retro_element, passed
19: p_payroll_id and p_assact_id to pay_core_dates.is_date_in_span()
20: vpallapo 28-SEP-2011 Bug 9881366 Changed recursion logic of calculating overlap date. In case of overlaps,
21: made use of ovl dates of previous retropay's ovl dates to reduce the
22: number of iterations in recursion.
23: priupadh 15-APR-2010 Bug 9405939 Now using retro element while creating negative retro run result values.

Line 519: and pay_core_dates.is_date_in_span

515: and prcu.creator_id = p_element_type_id
516: and prcu.creator_type = 'ET'
517: and prcu.retro_component_usage_id = pesu.retro_component_usage_id
518: and nvl(pesu.adjustment_type, 'A') = p_adjustment_type
519: and pay_core_dates.is_date_in_span
520: (pts.start_time_def_id,
521: pts.end_time_def_id,
522: p_run_eff_date,
523: p_retro_eff_date,

Line 563: and pay_core_dates.is_date_in_span

559: and prcu.creator_id = p_element_type_id
560: and prcu.creator_type = 'ET'
561: and prcu.retro_component_usage_id = pesu.retro_component_usage_id
562: and nvl(pesu.adjustment_type, 'A') = 'A'
563: and pay_core_dates.is_date_in_span
564: (pts.start_time_def_id,
565: pts.end_time_def_id,
566: p_run_eff_date,
567: p_retro_eff_date,