APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 301: CURSOR c_primary_regno( p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE ) IS --rchandan for bug#4428980

297: It will be inserted into jai_Rgm_trx_records table.
298: Bug# 4204880
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

Line 310: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

306: AND organization_type = p_organization_type
307: AND registration_type = jai_constants.regn_type_others
308: AND attribute_Type_code = p_att_type_code; --rchandan for bug#4428980
309:
310: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
311:
312:
313: /*Cursor added by ssawant for bug 5989740 */
314: CURSOR cur_fetch_ou(cp_organization_id NUMBER)

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 1274: FROM JAI_RGM_REGISTRATIONS tax_types,

1270: cp_account_name IN VARCHAR2
1271: )
1272: IS
1273: SELECT to_number(accnts.attribute_value)
1274: FROM JAI_RGM_REGISTRATIONS tax_types,
1275: jai_rgm_parties jrp ,
1276: JAI_RGM_REGISTRATIONS accnts
1277: WHERE tax_types.regime_id = cp_regime_id
1278: AND jrp.regime_id = -accnts.regime_id

Line 1276: JAI_RGM_REGISTRATIONS accnts

1272: IS
1273: SELECT to_number(accnts.attribute_value)
1274: FROM JAI_RGM_REGISTRATIONS tax_types,
1275: jai_rgm_parties jrp ,
1276: JAI_RGM_REGISTRATIONS accnts
1277: WHERE tax_types.regime_id = cp_regime_id
1278: AND jrp.regime_id = -accnts.regime_id
1279: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1280: AND tax_types.attribute_code = cp_tax_type

Line 1678: p_att_type_code jai_rgm_registrations.attribute_Type_code%TYPE) IS --rchandan for bug#4428980

1674: ) IS
1675:
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