APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_RCD_IN_FILE

Line 11: ben_ext_rcd_in_file rif,

7: cursor c_rcd_exists is
8: select '1' from dual where
9: exists (
10: select '1' from ben_ext_rcd r,
11: ben_ext_rcd_in_file rif,
12: ben_ext_file f
13: WHERE f.business_group_id is NULL
14: and f.ext_file_id =rif.ext_file_id
15: and r.ext_rcd_id = rif.ext_rcd_id

Line 28: update ben_ext_rcd_in_file

24: open c_rcd_exists;
25: fetch c_rcd_exists into l_var;
26: if(c_rcd_exists%notfound) then
27: hr_utility.set_location(' Incrementing sequence' , 10);
28: update ben_ext_rcd_in_file
29: set seq_num = seq_num * 10
30: where ext_FILE_ID = (select ext_FILE_ID from
31: ben_ext_file f
32: where f.business_group_id is NULL

Line 41: ,BEN_EXT_RCD_IN_FILE rif

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
41: ,BEN_EXT_RCD_IN_FILE rif
42: where f.business_group_id is NULL
43: and f.name = p_file_name
44: and rcd.EXT_RCD_ID =rif.ext_rcd_id
45: and f.EXT_FILE_ID =rif.EXT_FILE_ID

Line 2006: from ben_Ext_rcd_in_file erf,

2002: select erf.ext_rcd_in_file_id,
2003: rcd.ext_rcd_id
2004: into l_ext_rcd_in_file_id ,
2005: l_ext_rcd_id
2006: from ben_Ext_rcd_in_file erf,
2007: ben_Ext_rcd rcd
2008: where rcd.name = p_ext_group_record
2009: and rcd.ext_rcd_id = erf.ext_rcd_id
2010: and erf.ext_file_id = l_ext_file_id

Line 2426: FROM ben_ext_rcd_in_file

2422: BEGIN
2423: --rpinjala
2424: SELECT ext_rcd_in_file_id, object_version_number
2425: INTO l_ext_rcd_in_file_id,l_object_version_number
2426: FROM ben_ext_rcd_in_file
2427: WHERE ext_file_id = l_ext_file_id
2428: AND ext_rcd_id = l_ext_rcd_id
2429: AND seq_num = p_seq_num
2430: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')

Line 2477: from ben_ext_rcd_in_file

2473: l_tmp varchar2(1) ;
2474: Begin
2475: select object_version_number,ext_rcd_in_file_id
2476: into l_object_version_number,l_rcd_in_file_id
2477: from ben_ext_rcd_in_file
2478: where ext_file_id = l_ext_file_id
2479: and ext_rcd_id <> nvl(l_ext_rcd_id,-1)
2480: and seq_num = p_seq_num
2481: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;

Line 3374: FROM ben_ext_rcd_in_file

3370: END;
3371: BEGIN
3372: SELECT ext_rcd_in_file_id
3373: INTO l_ext_rcd_in_file_id
3374: FROM ben_ext_rcd_in_file
3375: WHERE ext_file_id = l_ext_file_id
3376: AND ext_rcd_id = l_ext_rcd_id
3377: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3378: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~');

Line 3652: FROM ben_ext_rcd_in_file

3648: END;
3649: BEGIN
3650: SELECT ext_rcd_in_file_id
3651: INTO l_ext_rcd_in_file_id
3652: FROM ben_ext_rcd_in_file
3653: WHERE ext_file_id = l_ext_file_id
3654: AND ext_rcd_id = l_ext_rcd_id
3655: AND NVL(legislation_code,'~NULL~')= NVL(l_legislation_code,'~NULL~')
3656: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;