DBA Data[Home] [Help]

APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_RGM_REGISTRATIONS

Line 1422: jai_rgm_registrations

1418: IS
1419: SELECT
1420: attribute_code tax_type
1421: FROM
1422: jai_rgm_registrations
1423: WHERE regime_id = pn_regime_id
1424: AND registration_type =jai_constants.regn_type_tax_types --tax type
1425: AND attribute_code = pv_tax_type_code;
1426:

Line 1435: jai_rgm_registrations tax_types

1431: IS
1432: SELECT
1433: TO_NUMBER (accnts.attribute_value)
1434: FROM
1435: jai_rgm_registrations tax_types
1436: , jai_rgm_registrations accnts
1437: WHERE tax_types.regime_id = pn_regime_id
1438: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1439: AND tax_types.attribute_code = pn_tax_type

Line 1436: , jai_rgm_registrations accnts

1432: SELECT
1433: TO_NUMBER (accnts.attribute_value)
1434: FROM
1435: jai_rgm_registrations tax_types
1436: , jai_rgm_registrations accnts
1437: WHERE tax_types.regime_id = pn_regime_id
1438: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1439: AND tax_types.attribute_code = pn_tax_type
1440: AND accnts.regime_id = tax_types.regime_id

Line 1450: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;

1446: vat_regimes_rec jai_regimes_cur%ROWTYPE;
1447: ln_dist_acct_ccid NUMBER;
1448: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
1449: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1450: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
1451:
1452: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1453: ln_proc_level NUMBER := FND_LOG.level_procedure;
1454: lv_proc_name VARCHAR2 (100) := 'Get_Dist_Account_Ccid';