APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_RGM_REGISTRATIONS

Line 1484: FROM jai_rgm_registrations

1480: SELECT 'Y'
1481: FROM dual
1482: WHERE EXISTS (
1483: SELECT 'X'
1484: FROM jai_rgm_registrations
1485: WHERE registration_type = jai_constants.regn_type_tax_types
1486: AND attribute_code = pv_tax_type
1487: AND regime_id IN ( SELECT regime_id
1488: FROM jai_rgm_definitions

Line 1694: jai_rgm_registrations

1690: IS
1691: SELECT
1692: attribute_code tax_type
1693: FROM
1694: jai_rgm_registrations
1695: WHERE regime_id = pn_regime_id
1696: AND registration_type =jai_constants.regn_type_tax_types --tax type
1697: AND attribute_code = pv_tax_type_code;
1698:

Line 1708: jai_rgm_registrations tax_types

1704: IS
1705: SELECT
1706: TO_NUMBER (accnts.attribute_value)
1707: FROM
1708: jai_rgm_registrations tax_types
1709: , jai_rgm_registrations accnts
1710: WHERE tax_types.regime_id = pn_regime_id
1711: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1712: AND tax_types.attribute_code = pn_tax_type

Line 1709: , jai_rgm_registrations accnts

1705: SELECT
1706: TO_NUMBER (accnts.attribute_value)
1707: FROM
1708: jai_rgm_registrations tax_types
1709: , jai_rgm_registrations accnts
1710: WHERE tax_types.regime_id = pn_regime_id
1711: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1712: AND tax_types.attribute_code = pn_tax_type
1713: AND accnts.regime_id = tax_types.regime_id

Line 1733: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;

1729: vat_regimes_rec jai_regimes_cur%ROWTYPE;
1730: ln_dist_acct_ccid NUMBER;
1731: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
1732: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1733: lv_regim_tax_type jai_rgm_registrations.attribute_code%TYPE;
1734:
1735: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
1736: ln_proc_level NUMBER := FND_LOG.level_procedure;
1737: lv_proc_name VARCHAR2 (100) := 'Get_Dist_Account_Ccid';