APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 82: FROM jai_rgm_registrations

78: /*
79: CURSOR c_get_st_accrual_date (p_regime_id NUMBER)
80: IS
81: SELECT to_date(attribute_value, 'DD/MM/YYYY')
82: FROM jai_rgm_registrations
83: WHERE regime_id = p_regime_id
84: AND attribute_code = 'EFF_DATE_ST_PT'
85: AND attribute_type_code = 'OTHERS'
86: AND registration_type = 'OTHERS';

Line 325: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

321: upper(jrttv.tax_type) = upper(cp_tax_type);
322:
323:
324: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
325: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
326:
327: -- Start of bug 4089440
328: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
329: lv_error_flag VARCHAR2(2) ;

Line 1337: FROM jai_rgm_registrations

1333: /*
1334: CURSOR c_get_st_accrual_date (p_regime_id NUMBER)
1335: IS
1336: SELECT to_date(attribute_value, 'DD/MM/YYYY')
1337: FROM jai_rgm_registrations
1338: WHERE regime_id = p_regime_id
1339: AND attribute_code = 'EFF_DATE_ST_PT'
1340: AND attribute_type_code = 'OTHERS'
1341: AND registration_type = 'OTHERS';

Line 1596: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

1592: upper(jrttv.tax_type) = upper(cp_tax_type);
1593:
1594:
1595: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1596: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1597:
1598: -- Start of bug 4089440
1599: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
1600: lv_error_flag VARCHAR2(2) ;