APPS.JAI_OM_RG_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 3147: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

3143: delivery_detail_id = p_header_id;
3144:
3145: CURSOR c_register_code IS
3146: SELECT A.register_code
3147: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
3148: WHERE A.organization_id = p_org_id
3149: AND A.location_id = p_location_id
3150: AND A.register_id = b.register_id
3151: AND b.order_flag = 'Y'

Line 4463: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;

4459:
4460: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4461: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4462: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4463: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4464: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4465: ln_header_id number;
4466: ln_cess_amount number;
4467: ln_Cess_Ctr number;