DBA Data[Home] [Help]

APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on FND_USER

Line 18: TYPE g_users_t IS TABLE OF fnd_user.user_name%type;

14: TYPE the_users IS REF CURSOR;
15:
16: TYPE g_person_sel_table_type IS TABLE OF pid;
17:
18: TYPE g_users_t IS TABLE OF fnd_user.user_name%type;
19:
20: g_actn VARCHAR2 (2000);
21: g_proc VARCHAR2 (80);
22: g_package VARCHAR2 (80) := 'BEN_CWB_MASS_NOTIFN_PKG';

Line 69: ,cursor ( select user_name from fnd_user usr

65: ,ppf.employee_number
66: ,ppf.person_id
67: ,null
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)

Line 82: FROM fnd_user usr

78: v_person_id IN NUMBER
79: )
80: IS
81: SELECT user_name
82: FROM fnd_user usr
83: WHERE usr.employee_id = v_person_id;
84:
85: CURSOR c_person_selection (
86: v_group_pl_id IN NUMBER

Line 568: FROM fnd_user

564: if((l_system_person_type <> 'EX_EMP')and(l_assignment_id is not null)) then
565:
566: SELECT user_name
567: INTO l_user_name
568: FROM fnd_user
569: WHERE user_id = fnd_global.user_id;
570: SELECT name
571: ,yr_perd_start_dt
572: ,yr_perd_end_dt

Line 1078: WRITE ('Employees with users defined in FND_USER : '|| l_emp_with_user);

1074: ------------------------------------------------------------
1075: */
1076: WRITE ('=============================================================================');
1077: WRITE ('Employees processed : '|| l_emp_processed);
1078: WRITE ('Employees with users defined in FND_USER : '|| l_emp_with_user);
1079: WRITE ('Employees with no users defined in FND_USER : '|| l_emp_with_no_user);
1080: WRITE ('Note: Notifications issued only to employee with defined user(s)');
1081: WRITE (' and satisfying criteria as provided in the concurrent request.');
1082: WRITE ('=============================================================================');

Line 1079: WRITE ('Employees with no users defined in FND_USER : '|| l_emp_with_no_user);

1075: */
1076: WRITE ('=============================================================================');
1077: WRITE ('Employees processed : '|| l_emp_processed);
1078: WRITE ('Employees with users defined in FND_USER : '|| l_emp_with_user);
1079: WRITE ('Employees with no users defined in FND_USER : '|| l_emp_with_no_user);
1080: WRITE ('Note: Notifications issued only to employee with defined user(s)');
1081: WRITE (' and satisfying criteria as provided in the concurrent request.');
1082: WRITE ('=============================================================================');
1083: WRITE ('Notifications sent : '|| g_sent_total);