APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on JTF_RS_GROUPS_VL

Line 7697: JTF_RS_GROUPS_VL JG

7693: x_contact_details.state,
7694: x_contact_details.country,
7695: x_contact_details.email
7696: FROM CSI_I_PARTIES CIP,
7697: JTF_RS_GROUPS_VL JG
7698: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7699: AND CIP.PARTY_ID = JG.GROUP_ID
7700: AND rownum < 2;
7701: EXCEPTION

Line 8152: FROM jtf_rs_groups_vl

8148: SELECT group_number,
8149: 'GROUP'
8150: INTO x_party_history_tbl(i).old_contact_party_number,
8151: x_party_history_tbl(i).old_contact_party_type
8152: FROM jtf_rs_groups_vl
8153: WHERE group_id = l_old_contact_party_id;
8154: EXCEPTION
8155: WHEN OTHERS THEN
8156: NULL;

Line 8239: FROM jtf_rs_groups_vl

8235: group_name
8236: INTO x_party_history_tbl(i).old_party_number,
8237: x_party_history_tbl(i).old_party_type,
8238: x_party_history_tbl(i).old_party_name
8239: FROM jtf_rs_groups_vl
8240: WHERE group_id = x_party_history_tbl(i).old_party_id;
8241: EXCEPTION
8242: WHEN OTHERS THEN
8243: NULL;

Line 8344: FROM jtf_rs_groups_vl

8340: SELECT group_number,
8341: 'GROUP'
8342: INTO x_party_history_tbl(i).new_contact_party_number,
8343: x_party_history_tbl(i).new_contact_party_type
8344: FROM jtf_rs_groups_vl
8345: WHERE group_id = l_new_contact_party_id;
8346: EXCEPTION
8347: WHEN OTHERS THEN
8348: NULL;

Line 8432: FROM jtf_rs_groups_vl

8428: group_name
8429: INTO x_party_history_tbl(i).new_party_number,
8430: x_party_history_tbl(i).new_party_type,
8431: x_party_history_tbl(i).new_party_name
8432: FROM jtf_rs_groups_vl
8433: WHERE group_id = x_party_history_tbl(i).new_party_id;
8434: EXCEPTION
8435: WHEN OTHERS THEN
8436: NULL;