DBA Data[Home] [Help]

APPS.JAI_GST_GENERAL_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 1117: jai_rgm_org_regns_v accnts

1113: cp_tax_type IN VARCHAR2,
1114: cp_account_name IN VARCHAR2) IS
1115: SELECT to_number(accnts.attribute_value)
1116: FROM jai_rgm_registrations tax_types,
1117: jai_rgm_org_regns_v accnts
1118: WHERE tax_types.regime_id = cp_regime_id
1119: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1120: AND tax_types.attribute_code = cp_tax_type
1121: AND accnts.regime_id = tax_types.regime_id

Line 1130: ln_location_id jai_rgm_org_regns_v.location_id%TYPE;

1126: AND accnts.organization_id = cp_organization_id
1127: AND (cp_location_id IS NULL OR location_id = cp_location_id);
1128:
1129: ln_code_combination_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
1130: ln_location_id jai_rgm_org_regns_v.location_id%TYPE;
1131: lv_regime_code jai_rgm_definitions.regime_code%TYPE;
1132:
1133: BEGIN
1134: