DBA Data[Home] [Help]

APPS.JAI_CMN_BOND_REGISTER_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 82: from JAI_OM_OE_BOND_TRXS

78: where hdr.register_id = p_register_id;
79:
80: Cursor c_get_bond_register_balance is
81: Select register_balance
82: from JAI_OM_OE_BOND_TRXS
83: where register_id = p_register_id
84: and transaction_id =
85: (select max(transaction_id)
86: from JAI_OM_OE_BOND_TRXS

Line 86: from JAI_OM_OE_BOND_TRXS

82: from JAI_OM_OE_BOND_TRXS
83: where register_id = p_register_id
84: and transaction_id =
85: (select max(transaction_id)
86: from JAI_OM_OE_BOND_TRXS
87: where register_id = p_register_id
88: );
89:
90: Cursor c_get_other_register_balance is

Line 92: from JAI_OM_OE_BOND_TRXS

88: );
89:
90: Cursor c_get_other_register_balance is
91: Select RG23D_REGISTER_BALANCE
92: from JAI_OM_OE_BOND_TRXS
93: where register_id = p_register_id
94: and transaction_id =
95: (select max(transaction_id)
96: from JAI_OM_OE_BOND_TRXS

Line 96: from JAI_OM_OE_BOND_TRXS

92: from JAI_OM_OE_BOND_TRXS
93: where register_id = p_register_id
94: and transaction_id =
95: (select max(transaction_id)
96: from JAI_OM_OE_BOND_TRXS
97: where register_id = p_register_id
98: );
99:
100: v_register_id Number;