APPS.JAI_AP_UTILS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 2339: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type ;

2335: RETURN VARCHAR2 IS
2336:
2337: lv_same_tds_batch VARCHAR2(1);
2338: lv_batch_name ap_batches_all.batch_name%TYPE;
2339: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type ;
2340: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;
2341:
2342: CURSOR c_regime_cur IS
2343: SELECT regime_id

Line 2344: FROM JAI_RGM_DEFINITIONS

2340: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;
2341:
2342: CURSOR c_regime_cur IS
2343: SELECT regime_id
2344: FROM JAI_RGM_DEFINITIONS
2345: WHERE regime_code = jai_constants.tds_regime;
2346:
2347: CURSOR c_attribute_value_cur(P_regime_id IN NUMBER, p_org_id number) is --added org_id parameter for bug#9149941
2348: SELECT attribute_Value

Line 2801: jai_rgm_definitions rgm_def

2797: TO_NUMBER(acc_rgm.attribute_value)
2798: INTO
2799: ln_tax_rgm_acc_id
2800: FROM
2801: jai_rgm_definitions rgm_def
2802: , jai_rgm_registrations tax_rgm
2803: , jai_rgm_registrations acc_rgm
2804: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2805: AND tax_rgm.regime_id = rgm_def.regime_id

Line 3465: jai_rgm_definitions def

3461: FUNCTION is_tds_calendar_missing RETURN VARCHAR2 IS
3462: cursor c_check_tds_calendar_setup is
3463: SELECT '1'
3464: FROM JAI_RGM_REGISTRATIONS reg,
3465: jai_rgm_definitions def
3466: WHERE
3467: reg.REGISTRATION_TYPE = 'OTHERS' AND
3468: reg.ATTRIBUTE_CODE = 'TDS_CALENDAR' AND
3469: reg.regime_id= def.regime_id AND