DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 2116: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type ;

2112: RETURN VARCHAR2 IS
2113:
2114: lv_same_tds_batch VARCHAR2(1);
2115: lv_batch_name ap_batches_all.batch_name%TYPE;
2116: ln_regime_id JAI_RGM_DEFINITIONS.regime_id%type ;
2117: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;
2118:
2119: CURSOR c_regime_cur IS
2120: SELECT regime_id

Line 2121: FROM JAI_RGM_DEFINITIONS

2117: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;
2118:
2119: CURSOR c_regime_cur IS
2120: SELECT regime_id
2121: FROM JAI_RGM_DEFINITIONS
2122: WHERE regime_code = jai_constants.tds_regime;
2123:
2124: CURSOR c_attribute_value_cur(P_regime_id IN NUMBER) is
2125: SELECT attribute_Value

Line 2576: jai_rgm_definitions rgm_def

2572: TO_NUMBER(acc_rgm.attribute_value)
2573: INTO
2574: ln_tax_rgm_acc_id
2575: FROM
2576: jai_rgm_definitions rgm_def
2577: , jai_rgm_registrations tax_rgm
2578: , jai_rgm_registrations acc_rgm
2579: WHERE regime_code IN (jai_constants.service_regime,jai_constants.vat_regime)
2580: AND tax_rgm.regime_id = rgm_def.regime_id