DBA Data[Home] [Help]

APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_RGM_PARTY_REGNS

Line 3092: jai_rgm_party_regns jpr

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
3096: AND jrr.registration_type = lv_oth_reg_type

Line 3103: jai_rgm_party_regns jpr

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 )
3107: AND jrp.organization_id = p_organization_id