APPS.HR_PAY_INTERFACE_PKG dependencies on HR_PAY_INTERFACE_OAB_VALUE_V

Line 7: g_eepyc_rec hr_pay_interface_oab_value_v%ROWTYPE;

3: --
4: -- OAB Benefit view functionality
5: --
6: -- non split globals
7: g_eepyc_rec hr_pay_interface_oab_value_v%ROWTYPE;
8: g_erpyc_rec hr_pay_interface_oab_value_v%ROWTYPE;
9: g_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
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;

Line 8: g_erpyc_rec hr_pay_interface_oab_value_v%ROWTYPE;

4: -- OAB Benefit view functionality
5: --
6: -- non split globals
7: g_eepyc_rec hr_pay_interface_oab_value_v%ROWTYPE;
8: g_erpyc_rec hr_pay_interface_oab_value_v%ROWTYPE;
9: g_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%TYPE;
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: --

Line 78: FROM hr_pay_interface_oab_value_v pi

74: p_effective_end_date IN DATE) IS
75: CURSOR csr_pay_interface_oab_value_v(c_acty_typ_cd
76: ben_prtt_rt_val.acty_typ_cd%TYPE) IS
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

Line 120: FROM hr_pay_interface_oab_value_v pi

116: p_effective_end_date IN DATE) RETURN VARCHAR2 IS
117: --
118: CURSOR csr_pay_interface_oab_value_v IS
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: --