DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on SSP_PAB_PKG

Line 303: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),

299: object_version_number,
300: decode(leave_type,
301: 'AD',ssp_sap_pkg.earliest_APP_start_date(due_date),
302: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
303: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
304: ssp_smp_pkg.earliest_MPP_start_date (due_date))
305: earliest_MPP_start_date
306: from ssp_maternities
307: where maternity_id = p_maternity_id;

Line 380: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),

376: object_version_number,
377: decode(leave_type,
378: 'AD',ssp_sap_pkg.earliest_APP_start_date(due_date),
379: 'PA',ssp_pad_pkg.earliest_PPP_start_date(due_date),
380: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
381: ssp_smp_pkg.earliest_MPP_start_date (due_date))
382: earliest_MPP_start_date,
383: ssp_smp_pkg.qualifying_week (due_date) QW,
384: nvl(mpp_start_date,hr_general.end_of_time) MPP,