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_AR_IMPORT_SYNC_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 975: JAI_RGM_ORG_REGNS_V

971: IS
972: SELECT
973: nvl(attribute_value ,'N') attribute_value
974: FROM
975: JAI_RGM_ORG_REGNS_V
976: WHERE
977: regime_code = jai_constants.vat_regime AND
978: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
979: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */

Line 1029: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;

1025:
1026: lv_enable_gst_flag VARCHAR2(1);
1027: ln_cgst_regime_id NUMBER;
1028: ln_sgst_regime_id NUMBER;
1029: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1030: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1031:
1032:
1033:

Line 1030: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;

1026: lv_enable_gst_flag VARCHAR2(1);
1027: ln_cgst_regime_id NUMBER;
1028: ln_sgst_regime_id NUMBER;
1029: lv_cgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1030: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1031:
1032:
1033:
1034: CURSOR cur_chk_gst_exists ( cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)

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

1030: lv_sgst_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE;
1031:
1032:
1033:
1034: CURSOR cur_chk_gst_exists ( cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE)
1035: IS
1036: SELECT regime_id ,
1037: regime_code
1038: FROM

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

1046: AND jtc.tax_type = jrttv.tax_type
1047: AND regime_code = cp_regime_code
1048: AND jtc.org_id = pr_new.org_id ;
1049:
1050: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1051: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,
1052: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE
1053: )
1054: IS

Line 1051: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,

1047: AND regime_code = cp_regime_code
1048: AND jtc.org_id = pr_new.org_id ;
1049:
1050: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1051: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,
1052: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE
1053: )
1054: IS
1055: SELECT regime_id,

Line 1052: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE

1048: AND jtc.org_id = pr_new.org_id ;
1049:
1050: CURSOR cur_get_gst_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1051: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE,
1052: cp_regime_code JAI_RGM_ORG_REGNS_V.REGIME_CODE%TYPE
1053: )
1054: IS
1055: SELECT regime_id,
1056: attribute_value

Line 1057: FROM JAI_RGM_ORG_REGNS_V orrg

1053: )
1054: IS
1055: SELECT regime_id,
1056: attribute_value
1057: FROM JAI_RGM_ORG_REGNS_V orrg
1058: WHERE orrg.organization_id = cp_organization_id
1059: AND orrg.location_id = cp_location_id
1060: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1061: AND attribute_code = jai_constants.attr_code_regn_no