APPS.CSI_UTL_PKG dependencies on CSI_INSTALL_PARAMETERS

Line 1498: FROM csi_install_parameters;

1494: --commented SQL below to make changes for the bug 4028827
1495: /*
1496: SELECT internal_party_id
1497: INTO x_int_party_id
1498: FROM csi_install_parameters;
1499: */
1500: x_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1501:
1502: IF x_int_party_id IS NULL THEN

Line 4283: From csi_install_parameters;

4279: /*
4280: BEGIN
4281: Select internal_party_id
4282: Into l_upd_party_tbl(1).party_id
4283: From csi_install_parameters;
4284:
4285: EXCEPTION
4286: When NO_Data_Found Then
4287: NULL;

Line 4415: FROM csi_install_parameters)

4411: CURSOR check_instance_status(p_instance_id IN NUMBER) IS
4412: SELECT distinct instance_number
4413: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir
4414: WHERE owner_party_id NOT IN (SELECT internal_party_id
4415: FROM csi_install_parameters)
4416: AND (cii.instance_id = cir.object_id or cii.instance_id = cir.subject_id)
4417: AND cir.relationship_type_code = 'COMPONENT-OF'
4418: AND (cii.active_end_date is null or cii.active_end_date > sysdate)
4419: AND (cir.active_end_date is null or cir.active_end_date > sysdate)