DBA Data[Home] [Help]

APPS.JAI_AP_UTILS_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 2340: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_Value%type ;

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
2344: FROM JAI_RGM_DEFINITIONS

Line 2349: FROM JAI_RGM_ORG_REGNS_V

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
2349: FROM JAI_RGM_ORG_REGNS_V
2350: WHERE regime_id = P_regime_id
2351: AND attribute_type_code = jai_constants.regn_type_others
2352: AND attribute_code = jai_constants.regn_type_tds_batch
2353: and organization_id = nvl(p_org_id, organization_id); --added for Bug#9149941