DBA Data[Home] [Help]

APPS.IGF_SL_DL_GEN_XML dependencies on IGF_SL_REP_AS_V

Line 1877: SELECT COUNT(*) INTO ln_as FROM igf_sl_rep_as_v WHERE document_id_txt = gv_document_id_txt;

1873: SELECT COUNT(*) INTO ln_top FROM igf_sl_cod_top_v WHERE document_id_txt = gv_document_id_txt;
1874: SELECT COUNT(*) INTO ln_sm FROM igf_sl_rep_smry_v WHERE document_id_txt = gv_document_id_txt;
1875: SELECT COUNT(*) INTO ln_rs FROM igf_sl_rep_rs_v WHERE document_id_txt = gv_document_id_txt;
1876: SELECT COUNT(*) INTO ln_rp FROM igf_sl_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1877: SELECT COUNT(*) INTO ln_as FROM igf_sl_rep_as_v WHERE document_id_txt = gv_document_id_txt;
1878: SELECT COUNT(*) INTO ln_st FROM igf_sl_rep_stdnt_v WHERE document_id_txt = gv_document_id_txt;
1879: SELECT COUNT(*) INTO ln_db FROM igf_sl_db_cod_rep_v WHERE document_id_txt = gv_document_id_txt;
1880: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1881: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug','ln_top ' ||ln_top);