APPS.HR_PAY_INTERFACE_PKG dependencies on HR_PAY_INTERFACE_OAB_VALUE2_V

Line 15: g_split_erpyc_rec hr_pay_interface_oab_value2_v%ROWTYPE;

11: g_coverage_type_tab g_coverage_type_typ;
12: --
13: -- split view globals
14: g_split_eepyc_rec hr_pay_interface_oab_value1_v%ROWTYPE;
15: g_split_erpyc_rec hr_pay_interface_oab_value2_v%ROWTYPE;
16: g_split_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
17: --
18: -- Procedures/functions for the non-split oab view
19: --

Line 462: FROM hr_pay_interface_oab_value2_v pi

458: p_effective_start_date IN DATE,
459: p_effective_end_date IN DATE) IS
460: CURSOR csr_pay_interface_oab_value_v IS
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

Line 529: FROM hr_pay_interface_oab_value2_v pi

525: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
526: --
527: CURSOR csr_pay_interface_oab_value_v IS
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: --