APPS.JAI_CMN_SETUP_PKG dependencies on JAI_OM_OE_BOND_REG_DTLS

Line 61: from JAI_OM_OE_BOND_REG_HDRS a , JAI_OM_OE_BOND_REG_DTLS b

57: where batch_source_id = p_order_invoice_type_id;
58:
59: Cursor c_get_register(p_orgn_id number,p_locn_id number,p_order_flag varchar2) is
60: select a.register_code
61: from JAI_OM_OE_BOND_REG_HDRS a , JAI_OM_OE_BOND_REG_DTLS b
62: where a.organization_id = p_orgn_id
63: and a.location_id = p_locn_id
64: and a.register_id = b.register_id
65: and b.order_flag = p_order_flag

Line 780: FROM JAI_OM_OE_BOND_REG_HDRS a, JAI_OM_OE_BOND_REG_DTLS b,sy_orgn_mst c

776:
777: -- start commted by Uday on 23-0CT-2001
778: /* Cursor register_code_cur ( s_orgn_code IN Varchar2 ) Is
779: SELECT a.register_code
780: FROM JAI_OM_OE_BOND_REG_HDRS a, JAI_OM_OE_BOND_REG_DTLS b,sy_orgn_mst c
781: WHERE a.organization_id = c.organization_id
782: AND UPPER(c.orgn_code) = UPPER(s_orgn_code) ------org_changed
783: AND a.register_id = b.register_id
784: AND b.order_flag = 'Y'

Line 794: FROM JAI_OM_OE_BOND_REG_HDRS a, JAI_OM_OE_BOND_REG_DTLS b,org_organization_definitions c

790:
791: -- start modified above code on 23-oct-2001 by Uday.
792: Cursor register_code_cur ( s_orgn_code IN Varchar2 ) Is
793: SELECT a.register_code
794: FROM JAI_OM_OE_BOND_REG_HDRS a, JAI_OM_OE_BOND_REG_DTLS b,org_organization_definitions c
795: WHERE a.organization_id = c.organization_id
796: AND UPPER(c.organization_code) = UPPER(s_orgn_code) ------org_changed
797: AND a.register_id = b.register_id
798: AND b.order_flag = 'Y'