eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ELIG_PROFILE_UTIL dependencies on BEN_ELIGY_PRFL_F

Line 243: from ben_eligy_prfl_f

239: eligy_prfl_id,
240: name,
241: asmt_to_use_cd,
242: business_group_id
243: from ben_eligy_prfl_f
244: where
245: eligy_prfl_id = p_elig_prof_id
246: and trunc(sysdate) between effective_start_date and effective_end_date
247: and stat_cd in ('A','P');

Line 251: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;

247: and stat_cd in ('A','P');
248:
249:
250:
251: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
252: l_elig_prof_name ben_eligy_prfl_f.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);

Line 252: l_elig_prof_name ben_eligy_prfl_f.name%type;

248:
249:
250:
251: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
252: l_elig_prof_name ben_eligy_prfl_f.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';

Line 253: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type;

249:
250:
251: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
252: l_elig_prof_name ben_eligy_prfl_f.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;

Line 254: l_elig_pro_bg_id ben_eligy_prfl_f.business_group_id%type;

250:
251: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
252: l_elig_prof_name ben_eligy_prfl_f.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;

Line 917: FROM ben_eligy_prfl_f

913: CURSOR get_elig_prof_details
914: (p_elig_prof_id IN number) IS
915: SELECT DISTINCT
916: asmt_to_use_cd
917: FROM ben_eligy_prfl_f
918: WHERE eligy_prfl_id = p_elig_prof_id
919: AND trunc (sysdate) BETWEEN effective_start_date
920: AND effective_end_date
921: AND stat_cd IN ('A','P');

Line 923: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%TYPE;

919: AND trunc (sysdate) BETWEEN effective_start_date
920: AND effective_end_date
921: AND stat_cd IN ('A','P');
922:
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;

Line 924: l_elig_prof_name ben_eligy_prfl_f.name%TYPE;

920: AND effective_end_date
921: AND stat_cd IN ('A','P');
922:
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;

Line 925: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%TYPE;

921: AND stat_cd IN ('A','P');
922:
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);

Line 942: ,elig_pro_bg_id ben_eligy_prfl_f.business_group_id%TYPE);

938: TYPE ug_rec IS RECORD (user_group_id ota_user_group_elements.user_group_id%TYPE
939: ,elig_prfl_id ota_user_group_elements.elig_prfl_id%TYPE
940: ,user_group_element_id ota_user_group_elements.user_group_element_id%TYPE
941: ,business_group_id ota_user_group_elements.business_group_id%TYPE
942: ,elig_pro_bg_id ben_eligy_prfl_f.business_group_id%TYPE);
943:
944: TYPE t_ug_rec IS TABLE OF ug_rec INDEX BY binary_integer;
945: user_elig_pro_rec t_ug_rec;
946: TYPE learner_assign_details IS REF CURSOR;

Line 989: ben_eligy_prfl_f bep

985: bep.business_group_id ep_business_group_id
986: from
987: ota_user_groups_b ug,
988: ota_user_group_elements uge,
989: ben_eligy_prfl_f bep
990: where
991: ug.user_group_id = uge.user_group_id
992: and trunc(sysdate) between trunc(ug.start_date_active) and nvl(ug.end_date_active,trunc(sysdate+1))
993: and uge.elig_prfl_id is not null

Line 1198: l_business_group_id ben_eligy_prfl_f.business_group_id%type;

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;
1199:
1200: TYPE ug_rec IS RECORD(
1201: user_group_id ota_user_group_elements.user_group_id%type,
1202: elig_prfl_id ota_user_group_elements.elig_prfl_id%type,

Line 1212: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;

1208:
1209: TYPE learner_assign_details IS REF CURSOR;
1210: csr_get_ug_to_be_processed learner_assign_details;
1211:
1212: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
1213: l_elig_prof_name ben_eligy_prfl_f.name%type;
1214: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type;
1215: begin
1216:

Line 1213: l_elig_prof_name ben_eligy_prfl_f.name%type;

1209: TYPE learner_assign_details IS REF CURSOR;
1210: csr_get_ug_to_be_processed learner_assign_details;
1211:
1212: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
1213: l_elig_prof_name ben_eligy_prfl_f.name%type;
1214: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type;
1215: begin
1216:
1217:

Line 1214: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type;

1210: csr_get_ug_to_be_processed learner_assign_details;
1211:
1212: l_elig_prof_id ben_eligy_prfl_f.eligy_prfl_id%type;
1213: l_elig_prof_name ben_eligy_prfl_f.name%type;
1214: l_asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type;
1215: begin
1216:
1217:
1218: if p_learner_group_id is not null and p_elig_prof_id is not null then