APPS.CSI_SYSTEMS_PVT dependencies on CSI_I_PARTIES

Line 2958: FROM csi_i_parties cip, csi_item_instances cii

2954: FOR UPDATE OF system_id ;
2955:
2956: CURSOR cont_csr IS
2957: SELECT party_id
2958: FROM csi_i_parties cip, csi_item_instances cii
2959: WHERE cip.instance_id=cii.instance_id
2960: AND cii.system_id=p_system_rec.system_id
2961: AND cip.relationship_type_code='OWNER'
2962: AND sysdate BETWEEN NVL(cii.active_start_date,sysdate)

Line 2968: csi_i_parties cip,

2964:
2965: CURSOR site_csr IS
2966: SELECT ip_account_id
2967: FROM csi_item_instances cii,
2968: csi_i_parties cip,
2969: csi_ip_accounts cia
2970: WHERE cii.instance_id=cip.instance_id
2971: AND cii.system_id=p_system_rec.system_id
2972: AND cip.instance_party_id=cia.instance_party_id

Line 2981: CSI_I_PARTIES cip,

2977: SELECT cip.instance_id instance_id,cip.instance_party_id instance_party_id,
2978: cip.object_version_number party_obj_version_number
2979: ,cia.ip_account_id ip_account_id,cia.object_version_number account_obj_version_number
2980: FROM CSI_ITEM_INSTANCES cii,
2981: CSI_I_PARTIES cip,
2982: CSI_IP_ACCOUNTS cia
2983: WHERE cii.system_id = p_system_rec.system_id
2984: AND cip.instance_id = cii.instance_id
2985: AND cip.relationship_type_code='OWNER'

Line 2996: CSI_I_PARTIES cip,

2992: CURSOR ip_acct_csr(p_bill_to IN NUMBER,p_ship_to IN NUMBER) IS
2993: SELECT cia.ip_account_id ip_account_id,cia.object_version_number object_version_number
2994: ,cia.bill_to_address,cia.ship_to_address
2995: FROM CSI_ITEM_INSTANCES cii,
2996: CSI_I_PARTIES cip,
2997: CSI_IP_ACCOUNTS cia
2998: WHERE cii.system_id = p_system_rec.system_id
2999: AND cip.instance_id = cii.instance_id
3000: AND cip.relationship_type_code='OWNER'

Line 3012: CSI_I_PARTIES cip

3008: --
3009: CURSOR ins_party_csr IS
3010: SELECT cip.instance_party_id instance_party_id
3011: FROM CSI_ITEM_INSTANCES cii,
3012: CSI_I_PARTIES cip
3013: WHERE cii.system_id = p_system_rec.system_id
3014: AND cip.instance_id = cii.instance_id
3015: AND cip.relationship_type_code = 'OWNER'
3016: AND sysdate BETWEEN NVL(cii.active_start_date,sysdate) AND NVL(cii.active_end_date,sysdate)

Line 3021: FROM CSI_I_PARTIES

3017: AND sysdate BETWEEN NVL(cip.active_start_date,sysdate) AND NVL(cip.active_end_date,sysdate);
3018: --
3019: CURSOR contact_ip_csr(p_contact_ip_id IN NUMBER) IS
3020: SELECT instance_party_id,object_version_number,party_id,relationship_type_code
3021: FROM CSI_I_PARTIES
3022: WHERE contact_ip_id = p_contact_ip_id
3023: AND contact_flag = 'Y'
3024: AND party_source_table = 'HZ_PARTIES'
3025: AND sysdate BETWEEN NVL(active_start_date,sysdate) AND NVL(active_end_date,sysdate);