APPS.CSD_REPAIRS_UTIL dependencies on CSI_I_PARTIES

Line 1270: from csi_i_parties

1266: -- Cursor to select the Instance party id
1267: Cursor c_instance_party(p_instance_id number) IS
1268: Select instance_party_id,
1269: object_version_number
1270: from csi_i_parties
1271: where instance_id = p_instance_id
1272: and relationship_type_code = 'OWNER'
1273: and sysdate between nvl(active_start_date, sysdate-1)
1274: and nvl(active_end_date, sysdate+1);

Line 1315: (SELECT instance_party_id FROM CSI_I_PARTIES

1311: Cursor get_bill_to_ship_to_address(p_instance_id number) IS
1312: SELECT bill_to_address,ship_to_address
1313: FROM CSI_IP_ACCOUNTS
1314: WHERE INSTANCE_PARTY_ID =
1315: (SELECT instance_party_id FROM CSI_I_PARTIES
1316: WHERE INSTANCE_ID=p_instance_id
1317: AND relationship_type_code='OWNER');
1318: --bug#8508030
1319:

Line 3746: FROM csi_i_parties

3742:
3743: BEGIN
3744: SELECT 'Y'
3745: INTO l_exists
3746: FROM csi_i_parties
3747: WHERE instance_id = p_instance_id
3748: AND relationship_type_code = p_relationship_type
3749: AND party_id = p_sr_party_id
3750: AND SYSDATE BETWEEN NVL(active_start_date,SYSDATE - 1) AND NVL(active_end_date, SYSDATE + 1);