APPS.JAI_OM_RG_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 2915: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b

2911: delivery_detail_id = p_header_id;
2912:
2913: CURSOR c_register_code IS
2914: SELECT A.register_code
2915: FROM JAI_OM_OE_BOND_REG_HDRS A, JAI_OM_OE_BOND_REG_DTLS b
2916: WHERE A.organization_id = p_org_id
2917: AND A.location_id = p_location_id
2918: AND A.register_id = b.register_id
2919: AND b.order_flag = 'Y'

Line 4054: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;

4050:
4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;
4054: v_order_type_id JAI_OM_OE_BOND_REG_DTLS.order_type_id%type;
4055: v_register_code JAI_OM_OE_BOND_REG_HDRS.register_code%type;
4056: ln_header_id number;
4057: ln_cess_amount number;
4058: ln_Cess_Ctr number;