[Home] [Help]
3376: WHERE credit_rating_id = p_credit_rating_id;
3377:
3378: CURSOR cFinNum IS
3379: SELECT FINANCIAL_number, financial_number_name
3380: FROM hz_financial_numbers
3381: WHERE financial_report_id in ( SELECT source_key
3382: from ar_cmgt_cf_dnb_dtls
3383: WHERE source_table_name = 'HZ_FINANCIAL_REPORTS'
3384: and case_folder_id = p_case_folder_id);