eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_DATA_POINTS_PKG dependencies on HZ_CREDIT_RATINGS

Line 3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;

3204: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3205:
3206: l_PAYDEX_SCORE Number;
3207: l_PAYDEX_THREE_MONTHS_AGO Number;
3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;

Line 3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;

3205:
3206: l_PAYDEX_SCORE Number;
3207: l_PAYDEX_THREE_MONTHS_AGO Number;
3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;

Line 3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;

3206: l_PAYDEX_SCORE Number;
3207: l_PAYDEX_THREE_MONTHS_AGO Number;
3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;

Line 3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;

3207: l_PAYDEX_THREE_MONTHS_AGO Number;
3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;

Line 3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;

3208: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;

Line 3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;

3209: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;

Line 3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;

3210: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;

Line 3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;

3211: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;

Line 3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;

3212: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;

Line 3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;

3213: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;

Line 3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;

3214: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;

Line 3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;

3215: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

Line 3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;

3216: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;

Line 3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;

3217: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;

Line 3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;

3218: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;

Line 3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

3219: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

Line 3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;

3220: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;

Line 3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;

3221: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;

Line 3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;

3222: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;

Line 3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

3223: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;

Line 3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;

3224: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;

Line 3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;

3225: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;

Line 3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;

3226: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;

Line 3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;

3227: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;

Line 3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;

3228: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;

Line 3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;

3229: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;

Line 3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;

3230: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;

Line 3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;

3231: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;

Line 3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;

3232: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;

Line 3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;

3233: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;

Line 3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;

3234: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;

Line 3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;

3235: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;

Line 3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;

3236: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;

Line 3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;

3237: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;

Line 3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;

3238: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;

Line 3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;

3239: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;

Line 3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;

3240: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;

Line 3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;

3241: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;

Line 3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;

3242: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;

Line 3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;

3243: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;

Line 3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;

3244: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;

Line 3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;

3245: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;

Line 3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;

3246: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3254: l_country hz_locations.country%type;

Line 3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;

3247: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3254: l_country hz_locations.country%type;
3255:

Line 3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;

3248: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3254: l_country hz_locations.country%type;
3255:
3256:

Line 3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;

3249: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3250: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3251: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3252: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3253: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3254: l_country hz_locations.country%type;
3255:
3256:
3257: l_cash_liqu_asset NUMBER;

Line 3375: FROM HZ_CREDIT_RATINGS

3371: DET_HISTORY_IND,
3372: OTHER_SPEC_EVNT_IND,
3373: OPRG_SPEC_EVNT_IND,
3374: CREDIT_SCORE_COMMENTARY
3375: FROM HZ_CREDIT_RATINGS
3376: WHERE credit_rating_id = p_credit_rating_id;
3377:
3378: CURSOR cFinNum IS
3379: SELECT FINANCIAL_number, financial_number_name

Line 4565: p_source_table_name => 'HZ_CREDIT_RATINGS',

4561: IF l_credit_rating_id IS NOT NULL
4562: THEN
4563: populate_dnb_data(
4564: p_case_folder_id => p_case_folder_id,
4565: p_source_table_name => 'HZ_CREDIT_RATINGS',
4566: p_source_key => l_credit_rating_id,
4567: p_source_key_column_name => 'CREDIT_RATING_ID',
4568: p_mode => p_mode
4569: );