APPS.HR_PAY_INTERFACE_PKG dependencies on HR_PAY_INTERFACE_OAB_VALUE1_V

Line 14: g_split_eepyc_rec hr_pay_interface_oab_value1_v%ROWTYPE;

10: TYPE g_coverage_type_typ IS TABLE OF ben_opt_f.name%TYPE INDEX BY BINARY_INTEGER;
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

Line 428: FROM hr_pay_interface_oab_value1_v pi

424: p_effective_start_date IN DATE,
425: p_effective_end_date IN DATE) IS
426: CURSOR csr_pay_interface_oab_value_v IS
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

Line 496: FROM hr_pay_interface_oab_value1_v pi

492: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
493: --
494: CURSOR csr_pay_interface_oab_value_v IS
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: --