APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on BEN_PER_IN_LER

Line 5: person_id ben_per_in_ler.person_id%type);

1: PACKAGE BODY BEN_CWB_MASS_NOTIFN_PKG as
2: /* $Header: bencwbnf.pkb 120.10.12010000.3 2008/09/18 07:31:00 sgnanama ship $ */
3:
4: TYPE pid IS RECORD (
5: person_id ben_per_in_ler.person_id%type);
6:
7: TYPE person_info IS RECORD (
8: full_name ben_cwb_person_info.full_name%type
9: ,name per_business_groups_perf.name%type

Line 11: ,person_id ben_per_in_ler.person_id%type

7: TYPE person_info IS RECORD (
8: full_name ben_cwb_person_info.full_name%type
9: ,name per_business_groups_perf.name%type
10: ,employee_number ben_cwb_person_info.employee_number%type
11: ,person_id ben_per_in_ler.person_id%type
12: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type);
13:
14: TYPE the_users IS REF CURSOR;
15:

Line 12: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type);

8: full_name ben_cwb_person_info.full_name%type
9: ,name per_business_groups_perf.name%type
10: ,employee_number ben_cwb_person_info.employee_number%type
11: ,person_id ben_per_in_ler.person_id%type
12: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type);
13:
14: TYPE the_users IS REF CURSOR;
15:
16: TYPE g_person_sel_table_type IS TABLE OF pid;

Line 101: ,ben_per_in_ler pil

97: ,max(per.employee_number)
98: ,max(pil.person_id)
99: ,max(pil.per_in_ler_id)
100: FROM ben_cwb_person_info per
101: ,ben_per_in_ler pil
102: ,ben_cwb_group_hrchy hrchy
103: ,hr_all_organization_units bg
104: WHERE per.group_pl_id = v_group_pl_id
105: AND per.lf_evt_ocrd_dt = v_lf_evt_orcd_date

Line 178: from ben_per_in_ler ler

174: OR
175: ((v_target_pop = 'MFX')
176: AND (hrchy.lvl_num = 0)
177: AND EXISTS (select ler.per_in_ler_stat_cd
178: from ben_per_in_ler ler
179: ,ben_cwb_group_hrchy hier
180: where hier.mgr_per_in_ler_id = pil.per_in_ler_id
181: and ler.per_in_ler_id = hier.emp_per_in_ler_id
182: and ler.per_in_ler_stat_cd = 'PROCD'))