APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 442: FROM JAI_RGM_ORG_REGNS_V

438: UPDATE jai_Rgm_trx_records
439: SET settlement_id = p_settlement_id
440: WHERE (organization_id,location_id) in
441: (SELECT organization_id,location_id
442: FROM JAI_RGM_ORG_REGNS_V
443: WHERE registration_id = p_regn_id
444: AND attribute_value = nvl(p_regn_no, attribute_value) -- 6835541. Added by Lakshmi Gopalsami
445: AND regime_code = 'VAT'
446: AND organization_id = nvl(p_org_id,organization_id)

Line 830: jai_rgm_trx_records a, JAI_RGM_ORG_REGNS_V b

826: a.organization_type , /*6835541*/
827: nvl(sum(a.debit_amount),0) debit_amt ,
828: nvl(sum(a.credit_amount),0) credit_amt
829: FROM
830: jai_rgm_trx_records a, JAI_RGM_ORG_REGNS_V b
831: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(b.regime_id,a.organization_id,a.location_id) ,g_start_date) and p_balance_date /*+ 1 removed by ssawant for bug 5662296*/
832: AND a.settlement_id IS NULL --added by csahoo for bug#6235971
833: AND b.regime_id = p_regime_id/*5694855 bduvarag*/
834: AND a.regime_code = lv_regime_code/*5694855 bduvarag*/

Line 942: FROM jai_rgm_org_regns_v

938: FOR tax_types_rec in
939: (
940: SELECT regime_id,
941: attribute_code tax_type
942: FROM jai_rgm_org_regns_v
943: WHERE organization_id = p_org_id
944: AND location_id = p_location_id
945: AND organization_type = p_org_type
946: AND registration_type = jai_constants.regn_type_tax_types

Line 1104: JAI_RGM_ORG_REGNS_V JOR

1100: JRR.ORGANIZATION_ID,
1101: JRR.REGIME_ID
1102: FROM JAI_RGM_REFS_ALL JRR,
1103: JAI_RGM_TAXES JRT,
1104: JAI_RGM_ORG_REGNS_V JOR
1105: WHERE JRR.TRX_REF_ID = JRT.TRX_REF_ID
1106: AND JRR.ORGANIZATION_ID = JOR.ORGANIZATION_ID
1107: AND JOR.REGIME_ID = JRR.REGIME_ID
1108: AND JOR.REGISTRATION_TYPE = 'TAX_TYPES'

Line 1252: from JAI_RGM_ORG_REGNS_V

1248: END IF;
1249: FOR io_rec IN
1250: ( select distinct
1251: organization_id, location_id
1252: from JAI_RGM_ORG_REGNS_V
1253: where organization_type = 'IO'
1254: and regime_code = 'SERVICE'
1255: )
1256: LOOP

Line 2251: jai_rgm_org_regns_v

2247: IS
2248: SELECT
2249: attribute_value
2250: FROM
2251: jai_rgm_org_regns_v
2252: WHERE
2253: --organization_type = 'OU' /*commented by vkaranam for bug#6773684*/
2254: organization_id = p_party_id
2255: AND regime_code = 'SERVICE'