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.

[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1382: JAI_RGM_ORG_REGNS_V

1378: IS
1379: SELECT
1380: nvl(attribute_value ,'N') attribute_value
1381: FROM
1382: JAI_RGM_ORG_REGNS_V
1383: WHERE
1384: regime_code = jai_constants.vat_regime AND
1385: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1386: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */

Line 1440: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;

1436: lv_gst_invoice_no JAI_AR_TRX_LINES.gst_invoice_no%TYPE;
1437:
1438: ln_cgst_regime_id NUMBER;
1439: ln_sgst_regime_id NUMBER;
1440: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1441: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1442:
1443: CURSOR cur_get_gst_invoice
1444: IS

Line 1441: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;

1437:
1438: ln_cgst_regime_id NUMBER;
1439: ln_sgst_regime_id NUMBER;
1440: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1441: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1442:
1443: CURSOR cur_get_gst_invoice
1444: IS
1445: SELECT gst_invoice_no

Line 1449: CURSOR cur_chk_gst_exists ( cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)

1445: SELECT gst_invoice_no
1446: FROM JAI_AR_TRXS
1447: WHERE customer_trx_id = pr_new.customer_trx_id ;
1448:
1449: CURSOR cur_chk_gst_exists ( cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)
1450: IS
1451: SELECT regime_id ,
1452: regime_code
1453: FROM

Line 1465: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,

1461: AND jtc.tax_type = jrttv.tax_type
1462: AND regime_code = cp_regime_code
1463: AND jtc.org_id = pr_new.org_id ;
1464:
1465: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1466: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,
1467: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE
1468: )
1469: IS

Line 1466: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,

1462: AND regime_code = cp_regime_code
1463: AND jtc.org_id = pr_new.org_id ;
1464:
1465: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1466: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,
1467: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE
1468: )
1469: IS
1470: SELECT regime_id,

Line 1467: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE

1463: AND jtc.org_id = pr_new.org_id ;
1464:
1465: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1466: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,
1467: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE
1468: )
1469: IS
1470: SELECT regime_id,
1471: attribute_value

Line 1472: FROM JAI_RGM_ORG_REGNS_V orrg

1468: )
1469: IS
1470: SELECT regime_id,
1471: attribute_value
1472: FROM JAI_RGM_ORG_REGNS_V orrg
1473: WHERE orrg.organization_id = cp_organization_id
1474: AND orrg.location_id = cp_location_id
1475: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1476: AND attribute_code = jai_constants.attr_code_regn_no

Line 2812: from JAI_RGM_ORG_REGNS_V

2808: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
2809: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
2810: CURSOR c_get_st_accrual_date(p_regime_id NUMBER, p_organization_id NUMBER, p_location_id NUMBER) IS
2811: select to_date(attribute_value, 'DD/MM/YYYY')
2812: from JAI_RGM_ORG_REGNS_V
2813: where regime_id = p_regime_id
2814: and organization_id = p_organization_id
2815: and location_id = p_location_id
2816: AND attribute_code = 'EFF_DATE_ST_PT'

Line 2821: from JAI_RGM_ORG_REGNS_V

2817: AND attribute_type_code = 'OTHERS'
2818: AND registration_type = 'OTHERS'
2819: AND (NOT EXISTS
2820: (select '1'
2821: from JAI_RGM_ORG_REGNS_V
2822: where regime_id = p_regime_id
2823: and attribute_code IN 'INV_ORG_CLASSIFICATION'
2824: and attribute_value <> 'ORGANIZATION'
2825: and organization_id = p_organization_id

Line 2830: from JAI_RGM_ORG_REGNS_V

2826: and location_id = p_location_id)
2827: OR
2828: NOT EXISTS
2829: (select '1'
2830: from JAI_RGM_ORG_REGNS_V
2831: where regime_id = p_regime_id
2832: and attribute_code IN 'SERVICE TYPE'
2833: and attribute_value <> 'OTHER'
2834: and organization_id = p_organization_id