APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on JTF_RS_TEAMS_VL

Line 7740: JTF_RS_TEAMS_VL JT

7736: x_contact_details.state,
7737: x_contact_details.country,
7738: x_contact_details.email
7739: FROM CSI_I_PARTIES CIP,
7740: JTF_RS_TEAMS_VL JT
7741: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7742: AND CIP.PARTY_ID = JT.TEAM_ID
7743: AND rownum < 2;
7744: EXCEPTION

Line 8164: FROM jtf_rs_teams_vl

8160: SELECT team_number,
8161: 'TEAM'
8162: INTO x_party_history_tbl(i).old_contact_party_number,
8163: x_party_history_tbl(i).old_contact_party_type
8164: FROM jtf_rs_teams_vl
8165: WHERE team_id = l_old_contact_party_id;
8166: EXCEPTION
8167: WHEN OTHERS THEN
8168: NULL;

Line 8253: FROM jtf_rs_teams_vl

8249: team_name
8250: INTO x_party_history_tbl(i).old_party_number,
8251: x_party_history_tbl(i).old_party_type,
8252: x_party_history_tbl(i).old_party_name
8253: FROM jtf_rs_teams_vl
8254: WHERE team_id = x_party_history_tbl(i).old_party_id;
8255: EXCEPTION
8256: WHEN OTHERS THEN
8257: NULL;

Line 8356: FROM jtf_rs_teams_vl

8352: SELECT team_number,
8353: 'TEAM'
8354: INTO x_party_history_tbl(i).new_contact_party_number,
8355: x_party_history_tbl(i).new_contact_party_type
8356: FROM jtf_rs_teams_vl
8357: WHERE team_id = x_party_history_tbl(i).new_party_id;
8358: EXCEPTION
8359: WHEN OTHERS THEN
8360: NULL;

Line 8446: FROM jtf_rs_teams_vl

8442: team_name
8443: INTO x_party_history_tbl(i).new_party_number,
8444: x_party_history_tbl(i).new_party_type,
8445: x_party_history_tbl(i).new_party_name
8446: FROM jtf_rs_teams_vl
8447: WHERE team_id = x_party_history_tbl(i).new_party_id;
8448: EXCEPTION
8449: WHEN OTHERS THEN
8450: NULL;