DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 1419: FROM JAI_OM_OE_BOND_TRXS

1415: WHERE organization_id = p_organization_id
1416: AND location_id = p_location_id;
1417: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1418: SELECT register_balance
1419: FROM JAI_OM_OE_BOND_TRXS
1420: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1422: WHERE A.register_id = B.register_id
1423: AND B.organization_id = p_organization_id

Line 1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1417: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1418: SELECT register_balance
1419: FROM JAI_OM_OE_BOND_TRXS
1420: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1422: WHERE A.register_id = B.register_id
1423: AND B.organization_id = p_organization_id
1424: AND B.location_id = p_location_id );
1425: CURSOR Get_Tax_Lines_Details_Cur1 IS