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 1964: ben_Ext_data_elmt_in_rcd der

1960:
1961: select der.Ext_data_elmt_in_rcd_id
1962: into l_ext_data_elmt_in_rcd_id1
1963: from ben_Ext_data_elmt elmt ,
1964: ben_Ext_data_elmt_in_rcd der
1965: where der.ext_rcd_id = l_Ext_rcd_id
1966: and elmt.ext_data_elmt_id = der.ext_data_elmt_id
1967: and elmt.name = p_ext_group_elmt1
1968: ;

Line 1975: ben_Ext_data_elmt_in_rcd der

1971:
1972: select der.Ext_data_elmt_in_rcd_id
1973: into l_ext_data_elmt_in_rcd_id2
1974: from ben_Ext_data_elmt elmt ,
1975: ben_Ext_data_elmt_in_rcd der
1976: where der.ext_rcd_id = l_Ext_rcd_id
1977: and elmt.ext_data_elmt_id = der.ext_data_elmt_id
1978: and elmt.name = p_ext_group_elmt2
1979: ;

Line 2255: from ben_ext_data_elmt_in_rcd eir , ben_ext_data_elmt elmt

2251: c_ext_rcd_id number ,
2252: c_legislation_code varchar2 ,
2253: c_new_business_group_id number ) is
2254: SELECT EXT_DATA_ELMT_IN_RCD_ID
2255: from ben_ext_data_elmt_in_rcd eir , ben_ext_data_elmt elmt
2256: where eir.ext_rcd_id = c_ext_rcd_id
2257: and eir.ext_data_elmt_id = elmt.ext_data_elmt_id
2258: and elmt.name = c_sort_element
2259: and NVL(eir.legislation_code,'~NULL~') = NVL(c_legislation_code,'~NULL~')

Line 3043: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;

3039: l_last_update_date DATE;
3040: l_last_updated_by NUMBER;
3041: l_new_business_group_id number ;
3042: l_ovn number ;
3043: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3044: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3045: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;

Line 3044: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;

3040: l_last_updated_by NUMBER;
3041: l_new_business_group_id number ;
3042: l_ovn number ;
3043: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3044: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3045: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3048: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;

Line 3045: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;

3041: l_new_business_group_id number ;
3042: l_ovn number ;
3043: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3044: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3045: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3048: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3049: BEGIN

Line 3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;

3042: l_ovn number ;
3043: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3044: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3045: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3048: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3049: BEGIN
3050: hr_utility.set_location(' Entering ' || l_proc, 10);

Line 3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;

3043: l_STRT_POS ben_ext_data_elmt_in_rcd.STRT_POS%type ;
3044: l_DLMTR_VAL ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
3045: l_HIDE_FLAG ben_ext_data_elmt_in_rcd.HIDE_FLAG%type ;
3046: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3047: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3048: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3049: BEGIN
3050: hr_utility.set_location(' Entering ' || l_proc, 10);
3051: get_who_values(p_owner => p_owner

Line 3101: FROM ben_ext_data_elmt_in_rcd

3097: l_DLMTR_VAL,
3098: l_RQD_FLAG ,
3099: l_HIDE_FLAG,
3100: l_SPRS_CD
3101: FROM ben_ext_data_elmt_in_rcd
3102: WHERE ext_rcd_id = l_ext_rcd_id
3103: AND ext_data_elmt_id = l_ext_data_elmt_id
3104: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3105: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')

Line 3162: from ben_ext_data_elmt_in_rcd

3158:
3159: cursor c_elmt_del1 (c_ext_data_elmt_id number ,
3160: c_Ext_rcd_id number ) is
3161: select object_version_number,ext_data_elmt_in_rcd_id
3162: from ben_ext_data_elmt_in_rcd
3163: where ext_data_elmt_id <> nvl(c_ext_data_elmt_id,-1)
3164: and ext_rcd_id = c_ext_rcd_id
3165: and seq_num = p_seq_num ;
3166:

Line 3371: FROM ben_ext_data_elmt_in_rcd rcd,

3367: -- the element in record may attched to different element for advance conditions
3368: -- the first select get the element in record
3369: SELECT ext_data_elmt_in_rcd_id
3370: INTO l_ext_data_elmt_in_rcd_id
3371: FROM ben_ext_data_elmt_in_rcd rcd,
3372: ben_ext_data_elmt elmt
3373: WHERE rcd.ext_rcd_id = l_ext_rcd_id
3374: and elmt.name = l_record_data_elmt_name
3375: AND rcd.ext_data_elmt_id = elmt.ext_data_elmt_id

Line 3385: FROM ben_ext_data_elmt_in_rcd

3381: -- this select get the element in advance condition
3382:
3383: SELECT ext_data_elmt_in_rcd_id
3384: INTO l_cond_ext_data_elmt_in_rcd_id
3385: FROM ben_ext_data_elmt_in_rcd
3386: WHERE ext_rcd_id = l_ext_rcd_id
3387: AND ext_data_elmt_id = l_ext_data_elmt_id
3388: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
3389: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');

Line 3628: FROM ben_ext_data_elmt_in_rcd

3624: END;
3625: BEGIN
3626: SELECT ext_data_elmt_in_rcd_id
3627: INTO l_ext_data_elmt_in_rcd_id
3628: FROM ben_ext_data_elmt_in_rcd
3629: WHERE ext_rcd_id = l_ext_rcd_id
3630: AND ext_data_elmt_id = l_ext_data_elmt_id
3631: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3632: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');