APPS.POA_DBI_REQ_F_C dependencies on FND_INSTALLATION

Line 16: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN

12: l_status VARCHAR2(30);
13: l_industry VARCHAR2(30);
14: l_stmt VARCHAR2(4000);
15: BEGIN
16: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
17: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_F';
18: EXECUTE immediate l_stmt;
19:
20: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';

Line 169: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN

165: l_batch_size := 10000;
166: END IF;
167:
168: bis_collection_utilities.log('Truncate Currency Conversion table: '|| 'Sysdate=' ||to_char(sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
169: IF (fnd_installation.GET_APP_INFO('POA', l_status, l_industry, l_poa_schema)) THEN
170: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_INC';
171: EXECUTE IMMEDIATE l_stmt;
172:
173: l_stmt := 'TRUNCATE TABLE ' || l_poa_schema || '.POA_DBI_REQ_RATES';

Line 605: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN

601:
602: COMMIT;
603: dbms_application_info.set_action('stats incremental');
604:
605: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
606: fnd_stats.gather_table_stats(ownname => l_poa_schema, tabname => 'POA_DBI_REQ_INC') ;
607: END IF;
608:
609: INSERT /*+ APPEND */ INTO poa_dbi_req_rates

Line 652: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN

648:
649: COMMIT;
650: dbms_application_info.set_action('stats rates');
651:
652: IF (fnd_installation.get_app_info('POA', l_status, l_industry, l_poa_schema)) THEN
653: fnd_stats.gather_table_stats(ownname => l_poa_schema,
654: tabname => 'POA_DBI_REQ_RATES') ;
655: END IF;
656: