APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_OM_OE_BOND_TRXS

Line 1086: FROM JAI_OM_OE_BOND_TRXS

1082: WHERE trx_number = v_parent_trx_number;
1083:
1084: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1085: SELECT NVL(register_balance,0) register_balance
1086: FROM JAI_OM_OE_BOND_TRXS
1087: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1088: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1089: WHERE A.register_id = B.register_id
1090: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);

Line 1088: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1084: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1085: SELECT NVL(register_balance,0) register_balance
1086: FROM JAI_OM_OE_BOND_TRXS
1087: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1088: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1089: WHERE A.register_id = B.register_id
1090: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1091:
1092: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 1094: FROM JAI_OM_OE_BOND_TRXS

1090: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1091:
1092: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1093: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
1094: FROM JAI_OM_OE_BOND_TRXS
1095: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1096: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1097: WHERE A.register_id = B.register_id
1098: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);

Line 1096: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B

1092: CURSOR register_balance_cur1(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1093: SELECT NVL(rg23d_register_balance,0) rg23d_register_balance
1094: FROM JAI_OM_OE_BOND_TRXS
1095: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1096: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1097: WHERE A.register_id = B.register_id
1098: AND B.organization_id = p_org_id AND B.location_id = p_loc_id);
1099:
1100: CURSOR line_cur IS