APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on JTF_RS_GROUPS_VL

Line 7747: JTF_RS_GROUPS_VL JG

7743: x_contact_details.state,
7744: x_contact_details.country,
7745: x_contact_details.email
7746: FROM CSI_I_PARTIES CIP,
7747: JTF_RS_GROUPS_VL JG
7748: WHERE CIP.INSTANCE_PARTY_ID = p_contact_party_id
7749: AND CIP.PARTY_ID = JG.GROUP_ID
7750: AND rownum < 2;
7751: EXCEPTION

Line 8202: FROM jtf_rs_groups_vl

8198: SELECT group_number,
8199: 'GROUP'
8200: INTO x_party_history_tbl(i).old_contact_party_number,
8201: x_party_history_tbl(i).old_contact_party_type
8202: FROM jtf_rs_groups_vl
8203: WHERE group_id = l_old_contact_party_id;
8204: EXCEPTION
8205: WHEN OTHERS THEN
8206: NULL;

Line 8289: FROM jtf_rs_groups_vl

8285: group_name
8286: INTO x_party_history_tbl(i).old_party_number,
8287: x_party_history_tbl(i).old_party_type,
8288: x_party_history_tbl(i).old_party_name
8289: FROM jtf_rs_groups_vl
8290: WHERE group_id = x_party_history_tbl(i).old_party_id;
8291: EXCEPTION
8292: WHEN OTHERS THEN
8293: NULL;

Line 8394: FROM jtf_rs_groups_vl

8390: SELECT group_number,
8391: 'GROUP'
8392: INTO x_party_history_tbl(i).new_contact_party_number,
8393: x_party_history_tbl(i).new_contact_party_type
8394: FROM jtf_rs_groups_vl
8395: WHERE group_id = l_new_contact_party_id;
8396: EXCEPTION
8397: WHEN OTHERS THEN
8398: NULL;

Line 8482: FROM jtf_rs_groups_vl

8478: group_name
8479: INTO x_party_history_tbl(i).new_party_number,
8480: x_party_history_tbl(i).new_party_type,
8481: x_party_history_tbl(i).new_party_name
8482: FROM jtf_rs_groups_vl
8483: WHERE group_id = x_party_history_tbl(i).new_party_id;
8484: EXCEPTION
8485: WHEN OTHERS THEN
8486: NULL;