APPS.OTA_ELIG_PROFILE_UTIL dependencies on OTA_USER_GROUPS_TL

Line 106: from ota_user_groups_tl

102:
103: cursor get_learner_group_name is
104: select
105: user_group_name
106: from ota_user_groups_tl
107: where
108: user_group_id = p_ug_id
109: and language = userenv('LANG');
110:

Line 111: l_lrnr_group_name ota_user_groups_tl.user_group_name%type;

107: where
108: user_group_id = p_ug_id
109: and language = userenv('LANG');
110:
111: l_lrnr_group_name ota_user_groups_tl.user_group_name%type;
112:
113: begin
114:
115: open get_learner_group_name;

Line 257: l_learner_group_name ota_user_groups_tl.user_group_name%type;

253: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type;
254: l_elig_pro_bg_id ben_eligy_prfl_f.business_group_id%type;
255: l_sql_stmnt varchar2(4000);
256: l_allow_contingent_wrk varchar2(1) := 'Y';
257: l_learner_group_name ota_user_groups_tl.user_group_name%type;
258: l_numberof_records_processed number:=0;
259: assignment_whereclause varchar2(100);
260: l_elig_obj_id number;
261: l_counter number:=0;

Line 927: l_learner_group_name ota_user_groups_tl.user_group_name%TYPE;

923: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;
924: l_elig_prof_name ben_eligy_prfl_f.name%TYPE;
925: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%TYPE;
926: l_allow_contingent_wrk varchar2(1) DEFAULT 'Y';
927: l_learner_group_name ota_user_groups_tl.user_group_name%TYPE;
928: l_numberof_records_processed number DEFAULT 0;
929: assignment_whereclause varchar2(100);
930: l_elig_obj_id number;
931: l_counter number DEFAULT 0;

Line 1194: l_learner_group_name ota_user_groups_tl.user_group_name%type;

1190: p_elig_prof_id in number) is
1191:
1192: --user_group_rec get_ug_to_be_processed%rowtype;
1193: l_counter number:=0;
1194: l_learner_group_name ota_user_groups_tl.user_group_name%type;
1195: l_learner_group_element_id ota_user_group_elements.user_group_element_id%type;
1196: ug_ep_whereclause varchar2(200);
1197: get_ug_to_be_processed varchar2(4000);
1198: l_business_group_id ben_eligy_prfl_f.business_group_id%type;