APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 1098: FROM JAI_OM_OE_BOND_TRXS

1094: WHERE trx_number = v_parent_trx_number;
1095:
1096: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1097: SELECT NVL(register_balance,0) register_balance
1098: FROM JAI_OM_OE_BOND_TRXS
1099: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1100: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1101: WHERE A.register_id = B.register_id
1102: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);

Line 1100: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1096: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1097: SELECT NVL(register_balance,0) register_balance
1098: FROM JAI_OM_OE_BOND_TRXS
1099: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1100: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1101: WHERE A.register_id = B.register_id
1102: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1103:
1104: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 1106: FROM JAI_OM_OE_BOND_TRXS

1102: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1103:
1104: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1105: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
1106: FROM JAI_OM_OE_BOND_TRXS
1107: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1108: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1109: WHERE A.register_id = B.register_id
1110: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);

Line 1108: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1104: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1105: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
1106: FROM JAI_OM_OE_BOND_TRXS
1107: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1108: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1109: WHERE A.register_id = B.register_id
1110: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1111:
1112: CURSOR line_cur IS