APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_FILE

Line 12: ben_ext_file f

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
16: and f.name = p_file_name

Line 31: ben_ext_file f

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
33: and f.name = p_file_name
34: AND f.name in ('ANSI-834 Full Profile','ANSI-834 Change Event'));
35:

Line 39: ben_ext_file f

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

Line 1973: l_xml_tag_name ben_ext_file.xml_tag_name%type ;

1969: l_last_updated_by NUMBER;
1970: l_sessionid NUMBER;
1971: l_new_business_group_id number ;
1972: l_ovn number ;
1973: l_xml_tag_name ben_ext_file.xml_tag_name%type ;
1974: l_legislation_code VARCHAR2(240);
1975:
1976: --
1977: BEGIN

Line 1996: FROM ben_ext_file

1992: XML_TAG_NAME
1993: INTO l_ext_file_id ,
1994: l_ovn,
1995: l_xml_tag_name
1996: FROM ben_ext_file
1997: WHERE name = p_file_name
1998: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
1999: AND nvl(legislation_code,'~NULL~') = nvl(l_legislation_code,'~NULL~');
2000:

Line 2085: l_xml_tag_name ben_ext_file.xml_tag_name%type ;

2081: l_last_updated_by NUMBER;
2082: l_sessionid NUMBER;
2083: l_new_business_group_id number ;
2084: l_ovn number ;
2085: l_xml_tag_name ben_ext_file.xml_tag_name%type ;
2086:
2087: l_proc varchar2(100) := 'BEN_EXT_SEED.load_extract' ;
2088:
2089: --

Line 2133: FROM ben_ext_file

2129: XML_TAG_NAME
2130: INTO l_ext_file_id ,
2131: l_ovn,
2132: l_xml_tag_name
2133: FROM ben_ext_file
2134: WHERE name = p_file_name
2135: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
2136: AND nvl(legislation_code,'~NULL~') = nvl(l_legislation_code,'~NULL~');
2137:

Line 2339: FROM ben_ext_file

2335:
2336: BEGIN
2337: SELECT ext_file_id
2338: INTO l_ext_file_id
2339: FROM ben_ext_file
2340: WHERE name = p_file_name
2341: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')
2342: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1);
2343:

Line 3362: FROM ben_ext_file

3358: IF p_file_name IS NOT NULL THEN
3359: BEGIN
3360: SELECT ext_file_id
3361: INTO l_ext_file_id
3362: FROM ben_ext_file
3363: WHERE name = p_file_name
3364: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3365: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3366: ;

Line 3641: FROM ben_ext_file

3637: IF p_file_name IS NOT NULL THEN
3638: BEGIN
3639: SELECT ext_file_id
3640: INTO l_ext_file_id
3641: FROM ben_ext_file
3642: WHERE name = p_file_name
3643: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3644: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;
3645: EXCEPTION

Line 4427: FROM ben_ext_file

4423:
4424: BEGIN
4425: SELECT ext_file_id
4426: INTO l_ext_file_id
4427: FROM ben_ext_file
4428: WHERE name = p_file_name
4429: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4430: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4431: EXCEPTION