APPS.HR_PAY_INTERFACE_PKG dependencies on HR_CERIDIAN

Line 81: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;

77: SELECT pi.*
78: FROM hr_pay_interface_oab_value_v pi
79: WHERE pi.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
80: AND pi.acty_typ_cd = c_acty_typ_cd
81: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;
82: BEGIN
83: -- set the g_prtt_enrt_rslt_id global
84: g_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;
85: -- get the eepyc record

Line 123: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;

119: SELECT 1
120: FROM hr_pay_interface_oab_value_v pi
121: WHERE pi.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
122: AND pi.acty_typ_cd IN ('EEPYC','ERPYC')
123: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;
124: --
125: l_dummy NUMBER(1);
126: --
127: BEGIN

Line 431: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;

427: SELECT pi.*
428: FROM hr_pay_interface_oab_value1_v pi
429: WHERE pi.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
430: AND pi.acty_typ_cd = 'EEPYC'
431: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;
432: BEGIN
433: -- set the g_split_prtt_enrt_rslt_id global
434: g_split_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;
435: g_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;

Line 465: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;

461: SELECT pi.*
462: FROM hr_pay_interface_oab_value2_v pi
463: WHERE pi.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
464: AND pi.acty_typ_cd = 'ERPYC'
465: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;
466: BEGIN
467: -- set the g_split_prtt_enrt_rslt_id global
468: g_split_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;
469: g_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id;

Line 499: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;

495: SELECT 1
496: FROM hr_pay_interface_oab_value1_v pi
497: WHERE pi.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
498: AND pi.acty_typ_cd = 'EEPYC'
499: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;
500: --
501: l_dummy NUMBER(1);
502: --
503: BEGIN

Line 532: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;

528: SELECT 1
529: FROM hr_pay_interface_oab_value2_v pi
530: WHERE pi.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
531: AND pi.acty_typ_cd = 'ERPYC'
532: AND pi.rt_strt_dt <= hr_ceridian.get_cer_extract_date;
533: --
534: l_dummy NUMBER(1);
535: --
536: BEGIN

Line 1099: hr_ceridian.g_cer_extract_date := p_payroll_extract_date;

1095: --
1096: begin
1097: g_payroll_extract_date := p_payroll_extract_date;
1098: hr_adp.g_adp_extract_date := p_payroll_extract_date;
1099: hr_ceridian.g_cer_extract_date := p_payroll_extract_date;
1100: --
1101: end set_extract_date;
1102: --
1103: -----------------------------------------------------------------------