APPS.JAI_CMN_RGM_RECORDING_PKG dependencies on JAI_RGM_REGISTRATIONS

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

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

Line 415: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

411: AND organization_type = p_organization_type
412: AND registration_type = jai_constants.regn_type_others
413: AND attribute_Type_code = p_att_type_code; --rchandan for bug#4428980
414:
415: lv_primary_regime_regno JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
416:
417:
418: /*Cursor added by ssawant for bug 5989740 */
419: CURSOR cur_fetch_ou(cp_organization_id NUMBER)

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

1715: cp_account_name IN VARCHAR2
1716: )
1717: IS
1718: SELECT to_number(accnts.attribute_value)
1719: FROM JAI_RGM_REGISTRATIONS tax_types,
1720: jai_rgm_parties jrp ,
1721: JAI_RGM_REGISTRATIONS accnts
1722: WHERE tax_types.regime_id = cp_regime_id
1723: AND jrp.regime_id = -accnts.regime_id

Line 1721: JAI_RGM_REGISTRATIONS accnts

1717: IS
1718: SELECT to_number(accnts.attribute_value)
1719: FROM JAI_RGM_REGISTRATIONS tax_types,
1720: jai_rgm_parties jrp ,
1721: JAI_RGM_REGISTRATIONS accnts
1722: WHERE tax_types.regime_id = cp_regime_id
1723: AND jrp.regime_id = -accnts.regime_id
1724: AND tax_types.registration_type = jai_constants.regn_type_tax_types
1725: AND tax_types.attribute_code = cp_tax_type

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

2131: ) IS
2132:
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