DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 205: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,

201: jtyi.legal_entity_id = cp_org_id
202: AND trunc(cp_trx_date) BETWEEN trunc(jtyi.start_date) and trunc(nvl(jtyi.end_date,sysdate)); --Added trunc by JMEENA for bug#9538920
203:
204: CURSOR c_get_rgm_attribute ( cp_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
205: cp_attribute_code JAI_RGM_REGISTRATIONS.ATTRIBUTE_CODE%TYPE ,
206: cp_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE
207: )
208: IS
209: SELECT