APPS.HR_PAY_INTERFACE_PKG dependencies on BEN_OPT_F

Line 10: TYPE g_coverage_type_typ IS TABLE OF ben_opt_f.name%TYPE INDEX BY BINARY_INTEGER;

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: --
13: -- split view globals
14: g_split_eepyc_rec hr_pay_interface_oab_value1_v%ROWTYPE;

Line 22: l_name ben_opt_f.name%TYPE;

18: -- Procedures/functions for the non-split oab view
19: --
20: --
21: FUNCTION GET_COVERAGE_TYPE(P_OIPL_ID IN NUMBER) RETURN VARCHAR2 AS
22: l_name ben_opt_f.name%TYPE;
23: -- define the cursor
24: CURSOR CSR1 IS SELECT opt.name /*coverage_type*/
25: FROM ben_opt_f opt,
26: ben_oipl_f cop

Line 25: FROM ben_opt_f opt,

21: FUNCTION GET_COVERAGE_TYPE(P_OIPL_ID IN NUMBER) RETURN VARCHAR2 AS
22: l_name ben_opt_f.name%TYPE;
23: -- define the cursor
24: CURSOR CSR1 IS SELECT opt.name /*coverage_type*/
25: FROM ben_opt_f opt,
26: ben_oipl_f cop
27: WHERE opt.opt_id = cop.opt_id
28: AND cop.oipl_id = P_OIPL_ID
29: AND cop.effective_start_date =

Line 36: FROM ben_opt_f opt1

32: WHERE cop1.oipl_id = cop.oipl_id
33: AND cop1.effective_start_date <= hr_pay_interface_pkg.get_extract_date)
34: AND opt.effective_start_date =
35: (SELECT max(opt1.effective_start_date)
36: FROM ben_opt_f opt1
37: WHERE opt1.opt_id = opt.opt_id
38: AND opt1.effective_start_date <= hr_pay_interface_pkg.get_extract_date);
39: BEGIN
40: -- check to see if a P_OIPL_ID exists if not short circuit out returning NULL