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

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

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

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

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

2582: l_last_updated_by NUMBER;
2583: l_tmp_id number ;
2584: l_tmp_ovn NUMBER;
2585: l_new_business_group_id number ;
2586: l_string ben_ext_data_elmt.string_val%type ;
2587: l_defined_balance_id number ;
2588: --
2589: CURSOR c_dt_rule(p_data_elmt_rl VARCHAR2
2590: ,l_new_business_group_id NUMBER

Line 2630: FROM ben_ext_data_elmt

2626: l_tmp_id := null ;
2627: l_tmp_ovn := null ;
2628: SELECT ext_data_elmt_id , object_version_number,string_val
2629: INTO l_tmp_id , l_tmp_ovn,l_string
2630: FROM ben_ext_data_elmt
2631: WHERE name = p_data_elemt_name
2632: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')
2633: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2634: ( p_business_group is null and business_group_id is null ) ) ;

Line 2706: FROM ben_ext_data_elmt

2702: l_tmp_id := null ;
2703: l_tmp_ovn := null ;
2704: SELECT ext_data_elmt_id , object_version_number,string_val
2705: INTO l_tmp_id , l_tmp_ovn,l_string
2706: FROM ben_ext_data_elmt
2707: WHERE name = p_data_elemt_name
2708: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2709: ( p_business_group is null and business_group_id is null ) )
2710: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 2794: FROM ben_ext_data_elmt

2790:
2791: IF p_parent_data_element <> 'NULL' THEN
2792: SELECT ext_data_elmt_id
2793: INTO l_parent_data_elmt_id
2794: FROM ben_ext_data_elmt
2795: WHERE name = p_parent_data_element
2796: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2797: ( p_business_group is null and business_group_id is null ) )
2798: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 2814: FROM ben_ext_data_elmt

2810: l_tmp_id := null ;
2811: l_tmp_ovn := null ;
2812: SELECT ext_data_elmt_id , object_version_number,string_val
2813: INTO l_tmp_id , l_tmp_ovn ,l_string
2814: FROM ben_ext_data_elmt
2815: WHERE name = p_data_elemt_name
2816: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2817: ( p_business_group is null and business_group_id is null ) )
2818: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 2915: FROM ben_ext_data_elmt

2911: l_tmp_id := null ;
2912: l_tmp_ovn := null ;
2913: SELECT ext_data_elmt_id , object_version_number ,string_val
2914: INTO l_tmp_id , l_tmp_ovn,l_string
2915: FROM ben_ext_data_elmt
2916: WHERE name = p_data_elemt_name
2917: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
2918: ( p_business_group is null and business_group_id is null ) )
2919: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 3002: FROM ben_ext_data_elmt

2998: l_tmp_id := null ;
2999: l_tmp_ovn := null ;
3000: SELECT ext_data_elmt_id , object_version_number ,string_val
3001: INTO l_tmp_id , l_tmp_ovn,l_string
3002: FROM ben_ext_data_elmt
3003: WHERE name = p_data_elemt_name
3004: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3005: ( p_business_group is null and business_group_id is null ) )
3006: AND NVL(legislation_code,'~NULL~') = NVL(l_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 3130: FROM ben_ext_data_elmt

3126: END;
3127: BEGIN
3128: SELECT ext_data_elmt_id
3129: INTO l_ext_data_elmt_id
3130: FROM ben_ext_data_elmt
3131: WHERE name = p_data_element_name
3132: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3133: ( p_business_group is null and business_group_id is null ) )
3134: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

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

3387:
3388: BEGIN
3389: SELECT ext_data_elmt_id
3390: INTO l_ext_data_elmt_id
3391: FROM ben_ext_data_elmt
3392: WHERE name = p_data_elmt_name
3393: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3394: ( p_business_group is null and business_group_id is null ) )
3395: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')

Line 3407: FROM ben_ext_data_elmt

3403: if p_cond_ext_data_elmt_name is not null then
3404: BEGIN
3405: SELECT ext_data_elmt_id
3406: INTO l_cond_ext_data_elmt_id
3407: FROM ben_ext_data_elmt
3408: WHERE name = p_cond_ext_data_elmt_name
3409: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3410: ( p_business_group is null and business_group_id is null ) )
3411: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

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

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

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

3667:
3668: BEGIN
3669: SELECT ext_data_elmt_id
3670: INTO l_ext_data_elmt_id
3671: FROM ben_ext_data_elmt
3672: WHERE name = p_data_elmt_name
3673: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
3674: ( p_business_group is null and business_group_id is null ) )
3675: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

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

Line 4640: FROM ben_ext_data_elmt

4636:
4637: BEGIN
4638: SELECT ext_data_elmt_id,ext_fld_id
4639: INTO l_ext_data_elmt_id,l_ext_fld_id
4640: FROM ben_ext_data_elmt
4641: WHERE name = p_element_name
4642: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or
4643: ( p_business_group is null and business_group_id is null ) )
4644: --AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 4686: FROM ben_ext_data_elmt_decd

4682: END;
4683: BEGIN
4684: SELECT 'Y'
4685: INTO l_temp
4686: FROM ben_ext_data_elmt_decd
4687: WHERE ext_data_elmt_id = l_ext_data_elmt_id
4688: AND val = p_val
4689: AND dcd_val = p_dcd_val
4690: AND ( ( nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)) or