APPS.JAI_GST_GENERAL_PKG dependencies on JAI_RGM_DEFINITIONS

Line 46: FROM JAI_RGM_DEFINITIONS jrd

42: FUNCTION IS_GST_ENABLED RETURN VARCHAR2
43: IS
44: CURSOR cur_gst_regime IS
45: SELECT 'Y'
46: FROM JAI_RGM_DEFINITIONS jrd
47: WHERE jrd.regime_code IN (jai_constants.sgst_regime,jai_constants.cgst_regime);
48:
49: v_gst_enabled VARCHAR2(1) := 'N';
50:

Line 1064: FROM jai_rgm_definitions

1060: FUNCTION get_regime_code(p_regime_id IN NUMBER) RETURN VARCHAR2 IS
1061:
1062: CURSOR c_regime_code(cp_regime_id IN NUMBER) IS
1063: SELECT regime_code
1064: FROM jai_rgm_definitions
1065: WHERE regime_id = cp_regime_id;
1066:
1067: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1068:

Line 1067: lv_regime_code jai_rgm_definitions.regime_code%TYPE;

1063: SELECT regime_code
1064: FROM jai_rgm_definitions
1065: WHERE regime_id = cp_regime_id;
1066:
1067: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1068:
1069: BEGIN
1070:
1071: OPEN c_regime_code(p_regime_id);

Line 1084: FROM jai_rgm_definitions

1080: FUNCTION get_regime_id(p_regime_code IN VARCHAR2) RETURN NUMBER IS
1081:
1082: CURSOR c_regime_id(cp_regime_code IN VARCHAR2) IS
1083: SELECT regime_id
1084: FROM jai_rgm_definitions
1085: WHERE regime_code = cp_regime_code;
1086:
1087: lv_regime_id jai_rgm_definitions.regime_id%TYPE;
1088:

Line 1087: lv_regime_id jai_rgm_definitions.regime_id%TYPE;

1083: SELECT regime_id
1084: FROM jai_rgm_definitions
1085: WHERE regime_code = cp_regime_code;
1086:
1087: lv_regime_id jai_rgm_definitions.regime_id%TYPE;
1088:
1089: BEGIN
1090:
1091: OPEN c_regime_id(p_regime_code);

Line 1131: lv_regime_code jai_rgm_definitions.regime_code%TYPE;

1127: AND (cp_location_id IS NULL OR location_id = cp_location_id);
1128:
1129: ln_code_combination_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1130: ln_location_id jai_rgm_org_regns_v.location_id%TYPE;
1131: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1132:
1133: BEGIN
1134:
1135: lv_regime_code := get_regime_code(p_regime_id);

Line 1330: JAI_RGM_DEFINITIONS JRG,

1326: ACC.ATTRIBUTE_VALUE ATTRIBUTE_VALUE,
1327: JRP.REGIME_ORG_ID
1328: FROM JAI_RGM_PARTIES JRP,
1329: JAI_RGM_REGISTRATIONS JRR,
1330: JAI_RGM_DEFINITIONS JRG,
1331: JAI_RGM_REGISTRATIONS ACC
1332: WHERE 1=1
1333: AND JRG.REGIME_ID = JRP.REGIME_ID
1334: AND JRG.REGIME_id = cn_regime_id --

Line 1352: JAI_RGM_DEFINITIONS JRG

1348: FROM JAI_RGM_PARTIES JRP,
1349: JAI_RGM_REGISTRATIONS JRR,
1350: JAI_RGM_REGISTRATIONS ACC,
1351: JAI_RGM_PARTY_REGNS JPR,
1352: JAI_RGM_DEFINITIONS JRG
1353: WHERE JRG.REGIME_ID = JRP.REGIME_ID
1354: AND JRG.REGIME_ID = cn_regime_id
1355: AND JRG.REGIME_ID = JRR.REGIME_ID
1356: AND ACC.attribute_code = cv_account_class