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.BEN_EXTRACT_SEED dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 36: update ben_EXT_DATA_ELMT_IN_RCD

32: where f.business_group_id is NULL
33: and f.name = p_file_name
34: AND f.name in ('ANSI-834 Full Profile','ANSI-834 Change Event'));
35:
36: update ben_EXT_DATA_ELMT_IN_RCD
37: set seq_num = seq_num * 10
38: where ext_rcd_id = (select rcd.ext_rcd_id from
39: ben_ext_file f
40: ,ben_ext_rcd rcd

Line 2017: ben_Ext_data_elmt_in_rcd der

2013:
2014: select der.Ext_data_elmt_in_rcd_id
2015: into l_ext_data_elmt_in_rcd_id1
2016: from ben_Ext_data_elmt elmt ,
2017: ben_Ext_data_elmt_in_rcd der
2018: where der.ext_rcd_id = l_Ext_rcd_id
2019: and elmt.ext_data_elmt_id = der.ext_data_elmt_id
2020: and elmt.name = p_ext_group_elmt1
2021: ;

Line 2028: ben_Ext_data_elmt_in_rcd der

2024:
2025: select der.Ext_data_elmt_in_rcd_id
2026: into l_ext_data_elmt_in_rcd_id2
2027: from ben_Ext_data_elmt elmt ,
2028: ben_Ext_data_elmt_in_rcd der
2029: where der.ext_rcd_id = l_Ext_rcd_id
2030: and elmt.ext_data_elmt_id = der.ext_data_elmt_id
2031: and elmt.name = p_ext_group_elmt2
2032: ;

Line 2311: from ben_ext_data_elmt_in_rcd eir , ben_ext_data_elmt elmt

2307: c_ext_rcd_id number ,
2308: c_legislation_code varchar2 ,
2309: c_new_business_group_id number ) is
2310: SELECT EXT_DATA_ELMT_IN_RCD_ID
2311: from ben_ext_data_elmt_in_rcd eir , ben_ext_data_elmt elmt
2312: where eir.ext_rcd_id = c_ext_rcd_id
2313: and eir.ext_data_elmt_id = elmt.ext_data_elmt_id
2314: and elmt.name = c_sort_element
2315: and NVL(eir.legislation_code,'~NULL~') = NVL(c_legislation_code,'~NULL~')

Line 3099: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;

3095: l_last_update_date DATE;
3096: l_last_updated_by NUMBER;
3097: l_new_business_group_id number ;
3098: l_ovn number ;
3099: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3100: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3101: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;

Line 3100: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;

3096: l_last_updated_by NUMBER;
3097: l_new_business_group_id number ;
3098: l_ovn number ;
3099: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3100: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3101: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3104: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;

Line 3101: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;

3097: l_new_business_group_id number ;
3098: l_ovn number ;
3099: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3100: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3101: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3104: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3105: BEGIN

Line 3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;

3098: l_ovn number ;
3099: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3100: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3101: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3104: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3105: BEGIN
3106: hr_utility.set_location(' Entering ' || l_proc, 10);

Line 3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;

3099: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3100: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3101: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3104: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3105: BEGIN
3106: hr_utility.set_location(' Entering ' || l_proc, 10);
3107: get_who_values(p_owner => p_owner

Line 3157: FROM ben_ext_data_elmt_in_rcd

3153: l_DLMTR_VAL,
3154: l_RQD_FLAG ,
3155: l_HIDE_FLAG,
3156: l_SPRS_CD
3157: FROM ben_ext_data_elmt_in_rcd
3158: WHERE ext_rcd_id = l_ext_rcd_id
3159: AND ext_data_elmt_id = l_ext_data_elmt_id
3160: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3161: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')

Line 3218: from ben_ext_data_elmt_in_rcd

3214:
3215: cursor c_elmt_del1 (c_ext_data_elmt_id number ,
3216: c_Ext_rcd_id number ) is
3217: select object_version_number,ext_data_elmt_in_rcd_id
3218: from ben_ext_data_elmt_in_rcd
3219: where ext_data_elmt_id <> nvl(c_ext_data_elmt_id,-1)
3220: and ext_rcd_id = c_ext_rcd_id
3221: and seq_num = p_seq_num ;
3222:

Line 3427: FROM ben_ext_data_elmt_in_rcd rcd,

3423: -- the element in record may attched to different element for advance conditions
3424: -- the first select get the element in record
3425: SELECT ext_data_elmt_in_rcd_id
3426: INTO l_ext_data_elmt_in_rcd_id
3427: FROM ben_ext_data_elmt_in_rcd rcd,
3428: ben_ext_data_elmt elmt
3429: WHERE rcd.ext_rcd_id = l_ext_rcd_id
3430: and elmt.name = l_record_data_elmt_name
3431: AND rcd.ext_data_elmt_id = elmt.ext_data_elmt_id

Line 3441: FROM ben_ext_data_elmt_in_rcd

3437: -- this select get the element in advance condition
3438:
3439: SELECT ext_data_elmt_in_rcd_id
3440: INTO l_cond_ext_data_elmt_in_rcd_id
3441: FROM ben_ext_data_elmt_in_rcd
3442: WHERE ext_rcd_id = l_ext_rcd_id
3443: AND ext_data_elmt_id = l_ext_data_elmt_id
3444: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
3445: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');

Line 3684: FROM ben_ext_data_elmt_in_rcd

3680: END;
3681: BEGIN
3682: SELECT ext_data_elmt_in_rcd_id
3683: INTO l_ext_data_elmt_in_rcd_id
3684: FROM ben_ext_data_elmt_in_rcd
3685: WHERE ext_rcd_id = l_ext_rcd_id
3686: AND ext_data_elmt_id = l_ext_data_elmt_id
3687: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3688: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');