APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_RCD_IN_FILE

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