APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on JTF_RS_TEAMS_VL

Line 7790: JTF_RS_TEAMS_VL JT

7786: x_contact_details.state,
7787: x_contact_details.country,
7788: x_contact_details.email
7789: FROM CSI_I_PARTIES CIP,
7790: JTF_RS_TEAMS_VL JT
7791: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7792: AND CIP.PARTY_ID = JT.TEAM_ID
7793: AND rownum < 2;
7794: EXCEPTION

Line 8214: FROM jtf_rs_teams_vl

8210: SELECT team_number,
8211: 'TEAM'
8212: INTO x_party_history_tbl(i).old_contact_party_number,
8213: x_party_history_tbl(i).old_contact_party_type
8214: FROM jtf_rs_teams_vl
8215: WHERE team_id = l_old_contact_party_id;
8216: EXCEPTION
8217: WHEN OTHERS THEN
8218: NULL;

Line 8303: FROM jtf_rs_teams_vl

8299: team_name
8300: INTO x_party_history_tbl(i).old_party_number,
8301: x_party_history_tbl(i).old_party_type,
8302: x_party_history_tbl(i).old_party_name
8303: FROM jtf_rs_teams_vl
8304: WHERE team_id = x_party_history_tbl(i).old_party_id;
8305: EXCEPTION
8306: WHEN OTHERS THEN
8307: NULL;

Line 8406: FROM jtf_rs_teams_vl

8402: SELECT team_number,
8403: 'TEAM'
8404: INTO x_party_history_tbl(i).new_contact_party_number,
8405: x_party_history_tbl(i).new_contact_party_type
8406: FROM jtf_rs_teams_vl
8407: WHERE team_id = x_party_history_tbl(i).new_party_id;
8408: EXCEPTION
8409: WHEN OTHERS THEN
8410: NULL;

Line 8496: FROM jtf_rs_teams_vl

8492: team_name
8493: INTO x_party_history_tbl(i).new_party_number,
8494: x_party_history_tbl(i).new_party_type,
8495: x_party_history_tbl(i).new_party_name
8496: FROM jtf_rs_teams_vl
8497: WHERE team_id = x_party_history_tbl(i).new_party_id;
8498: EXCEPTION
8499: WHEN OTHERS THEN
8500: NULL;