DBA Data[Home] [Help]

APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 1659: FROM JAI_OM_OE_BOND_TRXS

1655: WHERE organization_id = p_organization_id
1656: AND location_id = p_location_id;
1657: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1658: SELECT register_balance
1659: FROM JAI_OM_OE_BOND_TRXS
1660: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1662: WHERE A.register_id = B.register_id
1663: AND B.organization_id = p_organization_id

Line 1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1657: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1658: SELECT register_balance
1659: FROM JAI_OM_OE_BOND_TRXS
1660: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1662: WHERE A.register_id = B.register_id
1663: AND B.organization_id = p_organization_id
1664: AND B.location_id = p_location_id );
1665: CURSOR Get_Tax_Lines_Details_Cur1 IS