DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 3091: JAI_RGM_REGISTRATIONS jrr,

3087: -- to get PAN related to TAN
3088: CURSOR c_pan_number(p_organization_id IN NUMBER) IS --Harshita for bug#4889272
3089: /* SELECT jpr.attribute_value ORG_TAN_NUM
3090: FROM jai_rgm_parties jrp,
3091: JAI_RGM_REGISTRATIONS jrr,
3092: jai_rgm_party_regns jpr
3093: WHERE jrp.regime_org_id = jpr.regime_org_id
3094: AND jpr.registration_id = jrr.registration_id
3095: AND jrp.organization_id = p_organization_id

Line 3102: JAI_RGM_REGISTRATIONS jrr,

3098: AND jrr.attribute_code = lv_pan_att_code;*/
3099: SELECT NVL(jpr.attribute_value, jrr.attribute_value) ORG_TAN_NUM
3100: FROM
3101: jai_rgm_parties jrp,
3102: JAI_RGM_REGISTRATIONS jrr,
3103: jai_rgm_party_regns jpr
3104: WHERE
3105: jrp.regime_org_id = jpr.regime_org_id(+)
3106: AND ( jpr.registration_id is null or jpr.registration_id = jrr.registration_id )