APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 408: FROM JAI_RGM_ORG_REGNS_V

404: */
405:
406: CURSOR c_primary_regno( p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE ) IS --rchandan for bug#4428980
407: SELECT attribute_value
408: FROM JAI_RGM_ORG_REGNS_V
409: WHERE regime_id = p_regime_id
410: AND organization_id = p_organization_id
411: AND organization_type = p_organization_type
412: AND registration_type = jai_constants.regn_type_others

Line 1695: FROM JAI_RGM_REGISTRATIONS tax_types, JAI_RGM_ORG_REGNS_V accnts

1691: CURSOR c_orgn_tax_type_account(cp_regime_id IN NUMBER,
1692: cp_organization_type IN VARCHAR2, cp_organization_id IN NUMBER, cp_location_id IN NUMBER,
1693: cp_tax_type IN VARCHAR2, cp_account_name IN VARCHAR2) IS
1694: SELECT to_number(accnts.attribute_value)
1695: FROM JAI_RGM_REGISTRATIONS tax_types, JAI_RGM_ORG_REGNS_V accnts
1696: WHERE tax_types.regime_id = cp_regime_id
1697: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1698: AND tax_types.attribute_code = cp_tax_type
1699: AND accnts.regime_id = tax_types.regime_id

Line 2137: FROM JAI_RGM_ORG_REGNS_V

2133: CURSOR c_primary_regno(cp_regime_id IN NUMBER, cp_orgn_type in varchar2,
2134: cp_orgn_id in number, cp_location_id in number,
2135: p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE) IS --rchandan for bug#4428980
2136: SELECT attribute_value
2137: FROM JAI_RGM_ORG_REGNS_V
2138: WHERE regime_id = cp_regime_id
2139: AND organization_type = cp_orgn_type
2140: AND organization_id = cp_orgn_id
2141: and (cp_location_id is null or location_id = cp_location_id)

Line 2433: FROM JAI_RGM_ORG_REGNS_V

2429: CURSOR c_attribute_value (cp_regime_code IN varchar2,
2430: cp_orgn_type in varchar2, cp_orgn_id in number, cp_location_id in number,
2431: cp_registration_type in varchar2, cp_attribute_type_code in varchar2, cp_attribute_code in varchar2) IS
2432: SELECT attribute_value
2433: FROM JAI_RGM_ORG_REGNS_V
2434: WHERE regime_code = cp_regime_code
2435: AND organization_type = cp_orgn_type
2436: AND organization_id = cp_orgn_id
2437: and (cp_location_id is null or location_id = cp_location_id)

Line 2443: lv_attribute_code JAI_RGM_ORG_REGNS_V.attribute_code%type;

2439: AND ( (cp_attribute_code IS NOT NULL AND attribute_code = cp_attribute_code)
2440: or (cp_attribute_code IS NULL AND attribute_type_code = cp_attribute_type_code)
2441: );
2442:
2443: lv_attribute_code JAI_RGM_ORG_REGNS_V.attribute_code%type;
2444: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_value%type;
2445:
2446: ln_fetch_cnt NUMBER;
2447:

Line 2444: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_value%type;

2440: or (cp_attribute_code IS NULL AND attribute_type_code = cp_attribute_type_code)
2441: );
2442:
2443: lv_attribute_code JAI_RGM_ORG_REGNS_V.attribute_code%type;
2444: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_value%type;
2445:
2446: ln_fetch_cnt NUMBER;
2447:
2448: BEGIN