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

Line 1963: from ben_Ext_data_elmt elmt ,

1959:
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

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 1974: from ben_Ext_data_elmt elmt ,

1970: if p_ext_group_elmt2 is not null then
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

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 2530: l_string ben_ext_data_elmt.string_val%type ;

2526: l_last_updated_by NUMBER;
2527: l_tmp_id number ;
2528: l_tmp_ovn NUMBER;
2529: l_new_business_group_id number ;
2530: l_string ben_ext_data_elmt.string_val%type ;
2531: l_defined_balance_id number ;
2532: --
2533: CURSOR c_dt_rule(p_data_elmt_rl VARCHAR2
2534: ,l_new_business_group_id NUMBER

Line 2574: FROM ben_ext_data_elmt

2570: l_tmp_id := null ;
2571: l_tmp_ovn := null ;
2572: SELECT ext_data_elmt_id , object_version_number,string_val
2573: INTO l_tmp_id , l_tmp_ovn,l_string
2574: FROM ben_ext_data_elmt
2575: WHERE name = p_data_elemt_name
2576: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')
2577: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2578: ( p_business_group is null and business_group_id is null ) ) ;

Line 2650: FROM ben_ext_data_elmt

2646: l_tmp_id := null ;
2647: l_tmp_ovn := null ;
2648: SELECT ext_data_elmt_id , object_version_number,string_val
2649: INTO l_tmp_id , l_tmp_ovn,l_string
2650: FROM ben_ext_data_elmt
2651: WHERE name = p_data_elemt_name
2652: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2653: ( p_business_group is null and business_group_id is null ) )
2654: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 2738: FROM ben_ext_data_elmt

2734:
2735: IF p_parent_data_element <> 'NULL' THEN
2736: SELECT ext_data_elmt_id
2737: INTO l_parent_data_elmt_id
2738: FROM ben_ext_data_elmt
2739: WHERE name = p_parent_data_element
2740: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2741: ( p_business_group is null and business_group_id is null ) )
2742: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 2758: FROM ben_ext_data_elmt

2754: l_tmp_id := null ;
2755: l_tmp_ovn := null ;
2756: SELECT ext_data_elmt_id , object_version_number,string_val
2757: INTO l_tmp_id , l_tmp_ovn ,l_string
2758: FROM ben_ext_data_elmt
2759: WHERE name = p_data_elemt_name
2760: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2761: ( p_business_group is null and business_group_id is null ) )
2762: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 2859: FROM ben_ext_data_elmt

2855: l_tmp_id := null ;
2856: l_tmp_ovn := null ;
2857: SELECT ext_data_elmt_id , object_version_number ,string_val
2858: INTO l_tmp_id , l_tmp_ovn,l_string
2859: FROM ben_ext_data_elmt
2860: WHERE name = p_data_elemt_name
2861: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2862: ( p_business_group is null and business_group_id is null ) )
2863: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 2946: FROM ben_ext_data_elmt

2942: l_tmp_id := null ;
2943: l_tmp_ovn := null ;
2944: SELECT ext_data_elmt_id , object_version_number ,string_val
2945: INTO l_tmp_id , l_tmp_ovn,l_string
2946: FROM ben_ext_data_elmt
2947: WHERE name = p_data_elemt_name
2948: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2949: ( p_business_group is null and business_group_id is null ) )
2950: AND NVL(legislation_code,'~NULL~') = NVL(l_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 3074: FROM ben_ext_data_elmt

3070: END;
3071: BEGIN
3072: SELECT ext_data_elmt_id
3073: INTO l_ext_data_elmt_id
3074: FROM ben_ext_data_elmt
3075: WHERE name = p_data_element_name
3076: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3077: ( p_business_group is null and business_group_id is null ) )
3078: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

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 3335: FROM ben_ext_data_elmt

3331:
3332: BEGIN
3333: SELECT ext_data_elmt_id
3334: INTO l_ext_data_elmt_id
3335: FROM ben_ext_data_elmt
3336: WHERE name = p_data_elmt_name
3337: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3338: ( p_business_group is null and business_group_id is null ) )
3339: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')

Line 3351: FROM ben_ext_data_elmt

3347: if p_cond_ext_data_elmt_name is not null then
3348: BEGIN
3349: SELECT ext_data_elmt_id
3350: INTO l_cond_ext_data_elmt_id
3351: FROM ben_ext_data_elmt
3352: WHERE name = p_cond_ext_data_elmt_name
3353: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3354: ( p_business_group is null and business_group_id is null ) )
3355: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

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 3372: ben_ext_data_elmt elmt

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
3376: AND nvl( l_new_business_group_id, -1) = nvl(rcd.business_group_id , -1)

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 3615: FROM ben_ext_data_elmt

3611:
3612: BEGIN
3613: SELECT ext_data_elmt_id
3614: INTO l_ext_data_elmt_id
3615: FROM ben_ext_data_elmt
3616: WHERE name = p_data_elmt_name
3617: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3618: ( p_business_group is null and business_group_id is null ) )
3619: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

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~');

Line 4584: FROM ben_ext_data_elmt

4580:
4581: BEGIN
4582: SELECT ext_data_elmt_id,ext_fld_id
4583: INTO l_ext_data_elmt_id,l_ext_fld_id
4584: FROM ben_ext_data_elmt
4585: WHERE name = p_element_name
4586: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
4587: ( p_business_group is null and business_group_id is null ) )
4588: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 4630: FROM ben_ext_data_elmt_decd

4626: END;
4627: BEGIN
4628: SELECT 'Y'
4629: INTO l_temp
4630: FROM ben_ext_data_elmt_decd
4631: WHERE ext_data_elmt_id = l_ext_data_elmt_id
4632: AND val = p_val
4633: AND dcd_val = p_dcd_val
4634: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or