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 4325: From csi_install_parameters;

4321: /*
4322: BEGIN
4323: Select internal_party_id
4324: Into l_upd_party_tbl(1).party_id
4325: From csi_install_parameters;
4326:
4327: EXCEPTION
4328: When NO_Data_Found Then
4329: NULL;

Line 4457: FROM csi_install_parameters)

4453: CURSOR check_instance_status(p_instance_id IN NUMBER) IS
4454: SELECT distinct instance_number
4455: FROM CSI_ITEM_INSTANCES cii, CSI_II_RELATIONSHIPS cir
4456: WHERE owner_party_id NOT IN (SELECT internal_party_id
4457: FROM csi_install_parameters)
4458: AND (cii.instance_id = cir.object_id or cii.instance_id = cir.subject_id)
4459: AND cir.relationship_type_code = 'COMPONENT-OF'
4460: AND (cii.active_end_date is null or cii.active_end_date > sysdate)
4461: AND (cir.active_end_date is null or cir.active_end_date > sysdate)