DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on JTF_RS_TEAMS_VL

Line 329: FROM jtf_rs_teams_vl

325: CLOSE pty2_intf_cur;
326:
327: UPDATE CSI_I_PARTY_INTERFACE cpi
328: SET party_id=(SELECT team_id
329: FROM jtf_rs_teams_vl
330: WHERE team_name = cpi.party_name)
331: WHERE cpi.party_source_table = 'TEAM'
332: AND cpi.inst_interface_id IN (SELECT inst_interface_id
333: FROM csi_instance_interface cii

Line 854: FROM jtf_rs_teams_vl

850: CLOSE pty2_intf_cur;
851:
852: UPDATE CSI_I_PARTY_INTERFACE cpi
853: SET party_id = (SELECT team_id
854: FROM jtf_rs_teams_vl
855: WHERE team_name = cpi.party_name)
856: WHERE cpi.party_source_table = 'TEAM'
857: AND cpi.inst_interface_id IN (SELECT inst_interface_Id
858: FROM csi_instance_interface

Line 1178: FROM jtf_rs_teams_vl

1174: AND cpi.party_name IS NOT NULL;
1175:
1176: UPDATE CSI_I_PARTY_INTERFACE cpi
1177: SET party_id = (SELECT team_id
1178: FROM jtf_rs_teams_vl
1179: WHERE team_name = cpi.party_name)
1180: WHERE cpi.inst_interface_id IN (SELECT inst_interface_id
1181: FROM csi_instance_interface cii
1182: WHERE cii.transaction_identifier = p_txn_identifier)