eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_GST_GENERAL_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 1116: FROM jai_rgm_registrations tax_types,

1112: cp_location_id IN NUMBER,
1113: cp_tax_type IN VARCHAR2,
1114: cp_account_name IN VARCHAR2) IS
1115: SELECT to_number(accnts.attribute_value)
1116: FROM jai_rgm_registrations tax_types,
1117: jai_rgm_org_regns_v accnts
1118: WHERE tax_types.regime_id = cp_regime_id
1119: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1120: AND tax_types.attribute_code = cp_tax_type

Line 1278: FROM jai_rgm_registrations

1274: RETURN VARCHAR2 IS
1275:
1276: CURSOR get_others_attribute_value(cn_regime_id IN NUMBER) IS
1277: SELECT upper(attribute_value)
1278: FROM jai_rgm_registrations
1279: WHERE regime_id = cn_regime_id
1280: AND registration_type = 'OTHERS'
1281: AND attribute_code = 'TAX_ACCOUNTING';
1282:

Line 1283: lv_attribute_value jai_rgm_registrations.attribute_value%TYPE;

1279: WHERE regime_id = cn_regime_id
1280: AND registration_type = 'OTHERS'
1281: AND attribute_code = 'TAX_ACCOUNTING';
1282:
1283: lv_attribute_value jai_rgm_registrations.attribute_value%TYPE;
1284: v_debug char(1);
1285:
1286: BEGIN
1287: v_debug := jai_constants.NO;

Line 1329: JAI_RGM_REGISTRATIONS JRR,

1325: ORGANIZATION_ID,
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

Line 1331: JAI_RGM_REGISTRATIONS ACC

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 --
1335: AND JRG.REGIME_ID = JRR.REGIME_ID

Line 1349: JAI_RGM_REGISTRATIONS JRR,

1345: JPR.ATTRIBUTE_VALUE ATTRIBUTE_VALUE,
1346:
1347: JRP.REGIME_ORG_ID
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

Line 1350: JAI_RGM_REGISTRATIONS ACC,

1346:
1347: JRP.REGIME_ORG_ID
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

Line 1368: lv_tax_acct_setup_code jai_rgm_registrations.attribute_value%TYPE;

1364: ) B
1365: WHERE A.organization_id = B.organization_id(+)
1366: AND A.organization_id = cn_organization_id;
1367:
1368: lv_tax_acct_setup_code jai_rgm_registrations.attribute_value%TYPE;
1369: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
1370: lv_account_class jai_rgm_registrations.attribute_code%TYPE;
1371: lv_setup_type jai_rgm_registrations.registration_type%TYPE;
1372: lv_attribute_code jai_rgm_registrations.attribute_code%TYPE;

Line 1369: ln_regime_id jai_rgm_registrations.regime_id%TYPE;

1365: WHERE A.organization_id = B.organization_id(+)
1366: AND A.organization_id = cn_organization_id;
1367:
1368: lv_tax_acct_setup_code jai_rgm_registrations.attribute_value%TYPE;
1369: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
1370: lv_account_class jai_rgm_registrations.attribute_code%TYPE;
1371: lv_setup_type jai_rgm_registrations.registration_type%TYPE;
1372: lv_attribute_code jai_rgm_registrations.attribute_code%TYPE;
1373: ln_organization_id NUMBER(15);

Line 1370: lv_account_class jai_rgm_registrations.attribute_code%TYPE;

1366: AND A.organization_id = cn_organization_id;
1367:
1368: lv_tax_acct_setup_code jai_rgm_registrations.attribute_value%TYPE;
1369: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
1370: lv_account_class jai_rgm_registrations.attribute_code%TYPE;
1371: lv_setup_type jai_rgm_registrations.registration_type%TYPE;
1372: lv_attribute_code jai_rgm_registrations.attribute_code%TYPE;
1373: ln_organization_id NUMBER(15);
1374: ln_location_id NUMBER(15);

Line 1371: lv_setup_type jai_rgm_registrations.registration_type%TYPE;

1367:
1368: lv_tax_acct_setup_code jai_rgm_registrations.attribute_value%TYPE;
1369: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
1370: lv_account_class jai_rgm_registrations.attribute_code%TYPE;
1371: lv_setup_type jai_rgm_registrations.registration_type%TYPE;
1372: lv_attribute_code jai_rgm_registrations.attribute_code%TYPE;
1373: ln_organization_id NUMBER(15);
1374: ln_location_id NUMBER(15);
1375: ln_ccid NUMBER;

Line 1372: lv_attribute_code jai_rgm_registrations.attribute_code%TYPE;

1368: lv_tax_acct_setup_code jai_rgm_registrations.attribute_value%TYPE;
1369: ln_regime_id jai_rgm_registrations.regime_id%TYPE;
1370: lv_account_class jai_rgm_registrations.attribute_code%TYPE;
1371: lv_setup_type jai_rgm_registrations.registration_type%TYPE;
1372: lv_attribute_code jai_rgm_registrations.attribute_code%TYPE;
1373: ln_organization_id NUMBER(15);
1374: ln_location_id NUMBER(15);
1375: ln_ccid NUMBER;
1376: v_debug char(1);