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 3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;

3055: l_TOTAL_EMP_EST_IND hz_organization_profiles.TOTAL_EMP_EST_IND%type;
3056:
3057: l_PAYDEX_SCORE Number;
3058: l_PAYDEX_THREE_MONTHS_AGO Number;
3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;

Line 3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;

3056:
3057: l_PAYDEX_SCORE Number;
3058: l_PAYDEX_THREE_MONTHS_AGO Number;
3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;

Line 3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;

3057: l_PAYDEX_SCORE Number;
3058: l_PAYDEX_THREE_MONTHS_AGO Number;
3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;

Line 3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;

3058: l_PAYDEX_THREE_MONTHS_AGO Number;
3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;

Line 3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;

3059: l_AVG_HIGH_CREDIT HZ_CREDIT_RATINGS.AVG_HIGH_CREDIT%type;
3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;

Line 3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;

3060: l_HIGH_CREDIT HZ_CREDIT_RATINGS.HIGH_CREDIT%type;
3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;

Line 3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;

3061: l_CREDIT_SCORE_CLASS HZ_CREDIT_RATINGS.CREDIT_SCORE_CLASS%type;
3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;

Line 3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;

3062: l_CREDIT_SCORE_NATL_PERCENTILE HZ_CREDIT_RATINGS.CREDIT_SCORE_NATL_PERCENTILE%type;
3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;

Line 3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;

3063: l_CREDIT_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.CREDIT_SCORE_INCD_DEFAULT%type;
3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;

Line 3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;

3064: l_CREDIT_SCORE_AGE HZ_CREDIT_RATINGS.CREDIT_SCORE_AGE%type;
3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;

Line 3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;

3065: l_FAILURE_SCORE_CLASS HZ_CREDIT_RATINGS.FAILURE_SCORE_CLASS%type;
3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;

Line 3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;

3066: l_FAILURE_SCORE_NATNL_PERCENT HZ_CREDIT_RATINGS.FAILURE_SCORE_NATNL_PERCENTILE%type;
3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

Line 3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;

3067: l_FAILURE_SCORE_INCD_DEFAULT HZ_CREDIT_RATINGS.FAILURE_SCORE_INCD_DEFAULT%type;
3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;

Line 3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;

3068: l_FAILURE_SCORE_AGE HZ_CREDIT_RATINGS.FAILURE_SCORE_AGE%type;
3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;

Line 3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;

3069: l_LOW_RNG_DELQ_SCR HZ_CREDIT_RATINGS.LOW_RNG_DELQ_SCR%type;
3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;

Line 3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

3070: l_HIGH_RNG_DELQ_SCR HZ_CREDIT_RATINGS.HIGH_RNG_DELQ_SCR%type;
3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

Line 3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;

3071: l_DELQ_PMT_RNG_PRCNT HZ_CREDIT_RATINGS.DELQ_PMT_RNG_PRCNT%type;
3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;

Line 3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;

3072: l_DELQ_PMT_PCTG_FOR_ALL_FIRMS HZ_CREDIT_RATINGS.DELQ_PMT_PCTG_FOR_ALL_FIRMS%type;
3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;

Line 3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;

3073: l_NUM_TRADE_EXPERIENCES HZ_CREDIT_RATINGS.NUM_TRADE_EXPERIENCES%type;
3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;

Line 3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;

3074: l_DEBARMENTS_COUNT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;

Line 3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;

3075: l_BANKRUPTCY_IND HZ_CREDIT_RATINGS.BANKRUPTCY_IND%type;
3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;

Line 3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;

3076: l_DEBARMENT_IND HZ_CREDIT_RATINGS.DEBARMENT_IND%type;
3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;

Line 3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;

3077: l_BUSINESS_DISCONTINUED HZ_CREDIT_RATINGS.BUSINESS_DISCONTINUED%type;
3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;

Line 3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;

3078: l_NUM_SPCL_EVENT HZ_CREDIT_RATINGS.NUM_SPCL_EVENT%type;
3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;

Line 3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;

3079: l_MAXIMUM_CREDIT_CURRENCY_CODE HZ_CREDIT_RATINGS.MAXIMUM_CREDIT_CURRENCY_CODE%type;
3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;

Line 3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;

3080: l_CREDIT_SCORE HZ_CREDIT_RATINGS.CREDIT_SCORE%type;
3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;

Line 3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;

3081: l_CREDIT_SCORE_OVERRIDE_CODE HZ_CREDIT_RATINGS.CREDIT_SCORE_OVERRIDE_CODE%type;
3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;

Line 3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;

3082: l_PRNT_BKCY_CHAPTER_CONV HZ_CREDIT_RATINGS.PRNT_BKCY_CHAPTER_CONV%type;
3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;

Line 3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;

3083: l_NUM_PRNT_BKCY_CONVS HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_CONVS%type;
3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;

Line 3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;

3084: l_PRNT_BKCY_FILG_CHAPTER HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_CHAPTER%type;
3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;

Line 3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;

3085: l_PRNT_BKCY_FILG_TYPE HZ_CREDIT_RATINGS.PRNT_BKCY_FILG_TYPE%type;
3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;

Line 3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;

3086: l_NUM_PRNT_BKCY_FILING HZ_CREDIT_RATINGS.NUM_PRNT_BKCY_FILING%type;
3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;

Line 3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;

3087: l_NO_TRADE_IND HZ_CREDIT_RATINGS.NO_TRADE_IND%type;
3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;

Line 3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;

3088: l_JUDGEMENT_IND HZ_CREDIT_RATINGS.JUDGEMENT_IND%type;
3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;

Line 3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;

3089: l_LIEN_IND HZ_CREDIT_RATINGS.LIEN_IND%type;
3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;

Line 3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;

3090: l_SUIT_IND HZ_CREDIT_RATINGS.SUIT_IND%type;
3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;

Line 3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;

3091: l_PAYDEX_INDUSTRY_DAYS HZ_CREDIT_RATINGS.PAYDEX_INDUSTRY_DAYS%type;
3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;

Line 3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;

3092: l_FINCL_LGL_EVENT_IND HZ_CREDIT_RATINGS.FINCL_LGL_EVENT_IND%type;
3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;

Line 3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;

3093: l_DISASTER_IND HZ_CREDIT_RATINGS.DISASTER_IND%type;
3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;

Line 3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;

3094: l_CRIMINAL_PROCEEDING_IND HZ_CREDIT_RATINGS.CRIMINAL_PROCEEDING_IND%type;
3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;

Line 3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;

3095: l_FINCL_EMBT_IND HZ_CREDIT_RATINGS.FINCL_EMBT_IND%type;
3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;

Line 3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;

3096: l_PAYDEX_NORM HZ_CREDIT_RATINGS.PAYDEX_NORM%type;
3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;

Line 3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;

3097: l_RATING HZ_CREDIT_RATINGS.RATING%type;
3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3105: l_country hz_locations.country%type;

Line 3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;

3098: l_SECURED_FLNG_IND HZ_CREDIT_RATINGS.SECURED_FLNG_IND%type;
3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3105: l_country hz_locations.country%type;
3106:

Line 3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;

3099: l_CLAIMS_IND HZ_CREDIT_RATINGS.CLAIMS_IND%type;
3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3105: l_country hz_locations.country%type;
3106:
3107:

Line 3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;

3100: l_SUIT_JUDGE_IND HZ_CREDIT_RATINGS.SUIT_JUDGE_IND%type;
3101: l_DET_HISTORY_IND HZ_CREDIT_RATINGS.DET_HISTORY_IND%type;
3102: l_OTHER_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OTHER_SPEC_EVNT_IND%type;
3103: l_OPRG_SPEC_EVNT_IND HZ_CREDIT_RATINGS.OPRG_SPEC_EVNT_IND%type;
3104: l_CREDIT_SCORE_COMMENTARY HZ_CREDIT_RATINGS.CREDIT_SCORE_COMMENTARY%type;
3105: l_country hz_locations.country%type;
3106:
3107:
3108: l_cash_liqu_asset NUMBER;

Line 3226: FROM HZ_CREDIT_RATINGS

3222: DET_HISTORY_IND,
3223: OTHER_SPEC_EVNT_IND,
3224: OPRG_SPEC_EVNT_IND,
3225: CREDIT_SCORE_COMMENTARY
3226: FROM HZ_CREDIT_RATINGS
3227: WHERE credit_rating_id = p_credit_rating_id;
3228:
3229: CURSOR cFinNum IS
3230: SELECT FINANCIAL_number, financial_number_name

Line 4416: p_source_table_name => 'HZ_CREDIT_RATINGS',

4412: IF l_credit_rating_id IS NOT NULL
4413: THEN
4414: populate_dnb_data(
4415: p_case_folder_id => p_case_folder_id,
4416: p_source_table_name => 'HZ_CREDIT_RATINGS',
4417: p_source_key => l_credit_rating_id,
4418: p_source_key_column_name => 'CREDIT_RATING_ID',
4419: p_mode => p_mode
4420: );