APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_FILE

Line 1920: l_xml_tag_name ben_ext_file.xml_tag_name%type ;

1916: l_last_updated_by NUMBER;
1917: l_sessionid NUMBER;
1918: l_new_business_group_id number ;
1919: l_ovn number ;
1920: l_xml_tag_name ben_ext_file.xml_tag_name%type ;
1921: l_legislation_code VARCHAR2(240);
1922:
1923: --
1924: BEGIN

Line 1943: FROM ben_ext_file

1939: XML_TAG_NAME
1940: INTO l_ext_file_id ,
1941: l_ovn,
1942: l_xml_tag_name
1943: FROM ben_ext_file
1944: WHERE name = p_file_name
1945: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
1946: AND nvl(legislation_code,'~NULL~') = nvl(l_legislation_code,'~NULL~');
1947:

Line 2032: l_xml_tag_name ben_ext_file.xml_tag_name%type ;

2028: l_last_updated_by NUMBER;
2029: l_sessionid NUMBER;
2030: l_new_business_group_id number ;
2031: l_ovn number ;
2032: l_xml_tag_name ben_ext_file.xml_tag_name%type ;
2033:
2034: l_proc varchar2(100) := 'BEN_EXT_SEED.load_extract' ;
2035:
2036: --

Line 2077: FROM ben_ext_file

2073: XML_TAG_NAME
2074: INTO l_ext_file_id ,
2075: l_ovn,
2076: l_xml_tag_name
2077: FROM ben_ext_file
2078: WHERE name = p_file_name
2079: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1)
2080: AND nvl(legislation_code,'~NULL~') = nvl(l_legislation_code,'~NULL~');
2081:

Line 2283: FROM ben_ext_file

2279:
2280: BEGIN
2281: SELECT ext_file_id
2282: INTO l_ext_file_id
2283: FROM ben_ext_file
2284: WHERE name = p_file_name
2285: AND NVL(legislation_code,'~NULL~') = NVL(l_legislation_code,'~NULL~')
2286: AND nvl(l_new_business_group_id, -1) = nvl(business_group_id , -1);
2287:

Line 3306: FROM ben_ext_file

3302: IF p_file_name IS NOT NULL THEN
3303: BEGIN
3304: SELECT ext_file_id
3305: INTO l_ext_file_id
3306: FROM ben_ext_file
3307: WHERE name = p_file_name
3308: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3309: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3310: ;

Line 3585: FROM ben_ext_file

3581: IF p_file_name IS NOT NULL THEN
3582: BEGIN
3583: SELECT ext_file_id
3584: INTO l_ext_file_id
3585: FROM ben_ext_file
3586: WHERE name = p_file_name
3587: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~')
3588: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1) ;
3589: EXCEPTION

Line 4371: FROM ben_ext_file

4367:
4368: BEGIN
4369: SELECT ext_file_id
4370: INTO l_ext_file_id
4371: FROM ben_ext_file
4372: WHERE name = p_file_name
4373: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4374: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4375: EXCEPTION