APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on BEN_CWB_PERSON_INFO

Line 8: full_name ben_cwb_person_info.full_name%type

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
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);

Line 10: ,employee_number ben_cwb_person_info.employee_number%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
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;

Line 100: FROM ben_cwb_person_info per

96: ,max(bg.name)
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

Line 287: FROM ben_cwb_person_info info

283: v_group_per_in_ler_id IN NUMBER
284: )
285: IS
286: SELECT info.assignment_id
287: FROM ben_cwb_person_info info
288: ,per_assignments_f paf
289: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id
290: AND paf.assignment_id = info.assignment_id
291: AND sysdate BETWEEN paf.effective_start_date AND paf.effective_end_date;

Line 536: l_assignment_id ben_cwb_person_info.assignment_id%type;

532: l_trans_rec ben_transaction%rowtype;
533: l_user_name varchar2(100);
534: l_reject_reason varchar2(30);
535: l_system_person_type per_person_types.system_person_type%type;
536: l_assignment_id ben_cwb_person_info.assignment_id%type;
537: BEGIN
538:
539: if(v_people.per_in_ler_id is not null) then
540: