DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_RGM_ORG_REGNS_V

Line 673: FROM JAI_RGM_ORG_REGNS_V a

669: /*End of Bug# 4286646 */
670:
671: CURSOR c_regime_orgs(cp_regime_id IN NUMBER, cp_orgn_type IN VARCHAR2, cp_registration_num IN VARCHAR2,p_att_type_code jai_rgm_registrations.attribute_type_code%TYPE,cp_organization_id IN NUMBER ) IS/*Bug 5879769 bduvarag*/
672: SELECT a.organization_id org_id,a.location_id /*Bug 5879769 bduvarag*/
673: FROM JAI_RGM_ORG_REGNS_V a
674: WHERE regime_id = cp_regime_id
675: AND registration_type = jai_constants.regn_type_others
676: AND attribute_type_code = p_att_type_code--rchandan for bug#4428980
677: AND organization_type = cp_orgn_type

Line 1723: FROM JAI_RGM_ORG_REGNS_V

1719: WHERE delivery_id = cp_delivery_id;
1720:
1721: CURSOR c_same_inv_no(cp_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE , cp_location_id JAI_OM_WSH_LINES_ALL.location_id%TYPE ) IS
1722: SELECT attribute_Value
1723: FROM JAI_RGM_ORG_REGNS_V
1724: WHERE regime_id = p_regime_id
1725: AND attribute_type_code = jai_constants.regn_type_others
1726: AND attribute_code = jai_constants.attr_code_same_inv_no
1727: AND organization_id = cp_organization_id