APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 9: ,name per_business_groups_perf.name%type

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

Line 52: , per_business_groups_perf bg

48: ,ppf.business_group_id
49: FROM per_all_people_f ppf
50: , per_person_types ppt
51: , per_assignments_f paf
52: , per_business_groups_perf bg
53: WHERE ppf.person_id=paf.person_id
54: AND sysdate BETWEEN ppf.effective_start_date AND ppf.effective_end_date
55: AND paf.primary_flag = 'Y'
56: AND paf.business_group_id = ppf.business_group_id

Line 72: ,per_business_groups_perf bg

68: ,ppf.business_group_id
69: ,cursor ( select user_name from fnd_user usr
70: where usr.employee_id = ppf.person_id )
71: FROM per_all_people_f ppf
72: ,per_business_groups_perf bg
73: WHERE sysdate BETWEEN NVL(EFFECTIVE_START_DATE,sysdate)
74: AND NVL(EFFECTIVE_END_DATE,sysdate)
75: AND ppf.business_group_id = bg.business_group_id;
76: */