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_RCD

Line 1953: from ben_Ext_rcd_in_file erf,

1949: select erf.ext_rcd_in_file_id,
1950: rcd.ext_rcd_id
1951: into l_ext_rcd_in_file_id ,
1952: l_ext_rcd_id
1953: from ben_Ext_rcd_in_file erf,
1954: ben_Ext_rcd rcd
1955: where rcd.name = p_ext_group_record
1956: and rcd.ext_rcd_id = erf.ext_rcd_id
1957: and erf.ext_file_id = l_ext_file_id

Line 1954: ben_Ext_rcd rcd

1950: rcd.ext_rcd_id
1951: into l_ext_rcd_in_file_id ,
1952: l_ext_rcd_id
1953: from ben_Ext_rcd_in_file erf,
1954: ben_Ext_rcd rcd
1955: where rcd.name = p_ext_group_record
1956: and rcd.ext_rcd_id = erf.ext_rcd_id
1957: and erf.ext_file_id = l_ext_file_id
1958: ;

Line 2141: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;

2137: l_last_update_date DATE;
2138: l_last_updated_by NUMBER;
2139: l_new_business_group_id number ;
2140: l_ovn number ;
2141: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;
2142: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2143: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2144: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2145: BEGIN

Line 2142: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;

2138: l_last_updated_by NUMBER;
2139: l_new_business_group_id number ;
2140: l_ovn number ;
2141: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;
2142: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2143: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2144: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2145: BEGIN
2146: hr_utility.set_location(' Entering ' || l_proc, 10);

Line 2143: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;

2139: l_new_business_group_id number ;
2140: l_ovn number ;
2141: l_xml_tag_name ben_ext_rcd.xml_tag_name%type ;
2142: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2143: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2144: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2145: BEGIN
2146: hr_utility.set_location(' Entering ' || l_proc, 10);
2147: get_who_values(p_owner => p_owner

Line 2166: FROM ben_ext_rcd

2162: l_ovn,
2163: l_xml_tag_name,
2164: l_RCD_TYPE_CD,
2165: l_LOW_LVL_CD
2166: FROM ben_ext_rcd
2167: WHERE name = p_record_name
2168: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
2169: AND nvl(legislation_code,'~NULL~') = nvl(l_legislation_code,'~NULL~');
2170:

Line 2297: FROM ben_ext_rcd

2293:
2294: BEGIN
2295: SELECT ext_rcd_id
2296: INTO l_ext_rcd_id
2297: FROM ben_ext_rcd
2298: WHERE name = p_parent_record_name
2299: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')
2300: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1);
2301:

Line 2370: FROM ben_ext_rcd_in_file

2366: BEGIN
2367: --rpinjala
2368: SELECT ext_rcd_in_file_id, object_version_number
2369: INTO l_ext_rcd_in_file_id,l_object_version_number
2370: FROM ben_ext_rcd_in_file
2371: WHERE ext_file_id = l_ext_file_id
2372: AND ext_rcd_id = l_ext_rcd_id
2373: AND seq_num = p_seq_num
2374: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')

Line 2421: from ben_ext_rcd_in_file

2417: l_tmp varchar2(1) ;
2418: Begin
2419: select object_version_number,ext_rcd_in_file_id
2420: into l_object_version_number,l_rcd_in_file_id
2421: from ben_ext_rcd_in_file
2422: where ext_file_id = l_ext_file_id
2423: and ext_rcd_id <> nvl(l_ext_rcd_id,-1)
2424: and seq_num = p_seq_num
2425: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;

Line 2722: FROM ben_ext_rcd

2718: --- there is possible element creatd for forward reason
2719: if p_parent_record_name is not null then
2720: SELECT ext_rcd_id
2721: INTO l_ext_rcd_id
2722: FROM ben_ext_rcd
2723: WHERE name = p_parent_record_name
2724: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
2725: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');
2726: end if ;

Line 3063: FROM ben_ext_rcd

3059: BEGIN
3060:
3061: SELECT ext_rcd_id
3062: INTO l_ext_rcd_id
3063: FROM ben_ext_rcd
3064: WHERE name = p_record_name
3065: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3066: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;
3067: EXCEPTION

Line 3290: FROM ben_ext_rcd

3286: if p_record_name is not null then
3287: BEGIN
3288: SELECT ext_rcd_id
3289: INTO l_ext_rcd_id
3290: FROM ben_ext_rcd
3291: WHERE name = p_record_name
3292: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3293: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3294: ;

Line 3318: FROM ben_ext_rcd_in_file

3314: END;
3315: BEGIN
3316: SELECT ext_rcd_in_file_id
3317: INTO l_ext_rcd_in_file_id
3318: FROM ben_ext_rcd_in_file
3319: WHERE ext_file_id = l_ext_file_id
3320: AND ext_rcd_id = l_ext_rcd_id
3321: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3322: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 3572: FROM ben_ext_rcd

3568: ,p_business_group_id => l_new_business_group_id );
3569: BEGIN
3570: SELECT ext_rcd_id
3571: INTO l_ext_rcd_id
3572: FROM ben_ext_rcd
3573: WHERE name = p_record_name
3574: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3575: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;
3576: EXCEPTION

Line 3596: FROM ben_ext_rcd_in_file

3592: END;
3593: BEGIN
3594: SELECT ext_rcd_in_file_id
3595: INTO l_ext_rcd_in_file_id
3596: FROM ben_ext_rcd_in_file
3597: WHERE ext_file_id = l_ext_file_id
3598: AND ext_rcd_id = l_ext_rcd_id
3599: AND NVL(legislation_code,'~NULL~')= NVL(l_legislation_code,'~NULL~')
3600: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;