APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 303: FROM JAI_RGM_ORG_REGNS_V

299: */
300:
301: CURSOR c_primary_regno( p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE ) IS --rchandan for bug#4428980
302: SELECT attribute_value
303: FROM JAI_RGM_ORG_REGNS_V
304: WHERE regime_id = p_regime_id
305: AND organization_id = p_organization_id
306: AND organization_type = p_organization_type
307: AND registration_type = jai_constants.regn_type_others

Line 1250: FROM JAI_RGM_REGISTRATIONS tax_types, JAI_RGM_ORG_REGNS_V accnts

1246: CURSOR c_orgn_tax_type_account(cp_regime_id IN NUMBER,
1247: cp_organization_type IN VARCHAR2, cp_organization_id IN NUMBER, cp_location_id IN NUMBER,
1248: cp_tax_type IN VARCHAR2, cp_account_name IN VARCHAR2) IS
1249: SELECT to_number(accnts.attribute_value)
1250: FROM JAI_RGM_REGISTRATIONS tax_types, JAI_RGM_ORG_REGNS_V accnts
1251: WHERE tax_types.regime_id = cp_regime_id
1252: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1253: AND tax_types.attribute_code = cp_tax_type
1254: AND accnts.regime_id = tax_types.regime_id

Line 1680: FROM JAI_RGM_ORG_REGNS_V

1676: CURSOR c_primary_regno(cp_regime_id IN NUMBER, cp_orgn_type in varchar2,
1677: cp_orgn_id in number, cp_location_id in number,
1678: p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE) IS --rchandan for bug#4428980
1679: SELECT attribute_value
1680: FROM JAI_RGM_ORG_REGNS_V
1681: WHERE regime_id = cp_regime_id
1682: AND organization_type = cp_orgn_type
1683: AND organization_id = cp_orgn_id
1684: and (cp_location_id is null or location_id = cp_location_id)

Line 1976: FROM JAI_RGM_ORG_REGNS_V

1972: CURSOR c_attribute_value(cp_regime_code IN varchar2,
1973: cp_orgn_type in varchar2, cp_orgn_id in number, cp_location_id in number,
1974: cp_registration_type in varchar2, cp_attribute_type_code in varchar2, cp_attribute_code in varchar2) IS
1975: SELECT attribute_value
1976: FROM JAI_RGM_ORG_REGNS_V
1977: WHERE regime_code = cp_regime_code
1978: AND organization_type = cp_orgn_type
1979: AND organization_id = cp_orgn_id
1980: and (cp_location_id is null or location_id = cp_location_id)

Line 1986: lv_attribute_code JAI_RGM_ORG_REGNS_V.attribute_code%type;

1982: AND ( (cp_attribute_code IS NOT NULL AND attribute_code = cp_attribute_code)
1983: or (cp_attribute_code IS NULL AND attribute_type_code = cp_attribute_type_code)
1984: );
1985:
1986: lv_attribute_code JAI_RGM_ORG_REGNS_V.attribute_code%type;
1987: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_value%type;
1988:
1989: ln_fetch_cnt NUMBER;
1990:

Line 1987: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_value%type;

1983: or (cp_attribute_code IS NULL AND attribute_type_code = cp_attribute_type_code)
1984: );
1985:
1986: lv_attribute_code JAI_RGM_ORG_REGNS_V.attribute_code%type;
1987: lv_attribute_value JAI_RGM_ORG_REGNS_V.attribute_value%type;
1988:
1989: ln_fetch_cnt NUMBER;
1990:
1991: BEGIN